DBA Data[Home] [Help]

APPS.PAY_NL_IZA_UPLOAD dependencies on DUAL

Line 1284: from dual;

1280: ,l_contribution2
1281: ,l_corr_cont2
1282: ,l_iza_corr2_end_date
1283: ,NULL
1284: from dual;
1285:
1286:
1287: ELSE
1288:

Line 1289: select decode(l_reject_reason_code1,'00',decode(l_reject_reason_code2,'00',l_reject_reason_code3,l_reject_reason_code2),l_reject_reason_code1) into l_reject_code from dual;

1285:
1286:
1287: ELSE
1288:
1289: select decode(l_reject_reason_code1,'00',decode(l_reject_reason_code2,'00',l_reject_reason_code3,l_reject_reason_code2),l_reject_reason_code1) into l_reject_code from dual;
1290: l_process_status:='REJECTED';
1291:
1292: insert into PAY_NL_IZA_UPLD_STATUS( BUSINESS_GROUP_ID
1293: ,ORGANIZATION_ID

Line 1332: from dual;

1328: ,l_contribution2
1329: ,l_corr_cont2
1330: ,l_iza_corr2_end_date
1331: ,l_reject_code
1332: from dual;
1333:
1334:
1335: END IF;
1336: