>if (IsNull(cursor_trans_stage.cDischarge_status_code_fk) ; > and isnull(cursor_trans_stage.cAdmit_type_code_fk) ; > and isnull(cursor_trans_stage.cAdmit_Source_code_fk)) or ; > (nvl(cursor_trans_stage.cDischarge_status_code_fk,"A") == ; > nvl(Load_Trans.cDischarge_status_code_fk,"A") and ; > nvl(cursor_trans_stage.cAdmit_type_code_fk,"A") == ; > nvl(Load_Trans.cAdmit_type_code_fk,"A") and ; > nvl(cursor_trans_stage.cAdmit_Source_code_fk,"A") == ; > nvl(Load_Trans.cAdmit_Source_code_fk,"A")) > ** Do nothing - all empty or exactly the same > else > replace cDischarge_status_code_fk ; > with nvl(Load_Trans.cDischarge_status_code_fk, ; > cursor_trans_stage.cDischarge_status_code_fk), ; > cAdmit_type_code_fk ; > with nvl(Load_Trans.cAdmit_type_code_fk, ; > cursor_trans_stage.cAdmit_type_code_fk), ; > cAdmit_Source_code_fk ; > with nvl(Load_Trans.cAdmit_Source_code_fk, ; > cursor_trans_stage.cAdmit_Source_code_fk) in Load_Trans > endif>