APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on DUAL

Line 402: DUAL

398: IBY_REJECTED_DOCS_GROUP_S.NEXTVAL
399: INTO
400: l_rejection_id
401: FROM
402: DUAL
403: ;
404:
405: /*
406: * Update the removed document with the rejected document

Line 695: DUAL

691: IBY_REJECTED_DOCS_GROUP_S.NEXTVAL
692: INTO
693: l_rejection_id
694: FROM
695: DUAL
696: ;
697: FOR i IN p_doc_list.FIRST .. p_doc_list.LAST LOOP
698:
699:

Line 996: DUAL

992: IBY_REJECTED_DOCS_GROUP_S.NEXTVAL
993: INTO
994: l_rejection_id
995: FROM
996: DUAL
997: ;
998:
999: /*
1000: * Update the removed documents with the rejected document

Line 1604: DUAL

1600: IBY_REJECTED_DOCS_GROUP_S.NEXTVAL
1601: INTO
1602: l_rejection_id
1603: FROM
1604: DUAL
1605: ;
1606:
1607: /*
1608: * Update the removed documents with the rejected document

Line 5161: DUAL

5157: IBY_REJECTED_DOCS_GROUP_S.NEXTVAL
5158: INTO
5159: l_rejection_id
5160: FROM
5161: DUAL
5162: ;
5163:
5164: /*
5165: * Update the terminated documents for this calling app

Line 5526: * User has to proceed with the termination of individual

5522: WHERE PAYMENT_SERVICE_REQUEST_ID = p_req_id;
5523:
5524: /* If instructions are not created for this batch alone,
5525: * this ppr cannot be terminated.
5526: * User has to proceed with the termination of individual
5527: * instructions
5528: */
5529: IF l_straight_thr_proc <> 'Y' THEN
5530: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5776: DUAL

5772: IBY_REJECTED_DOCS_GROUP_S.NEXTVAL
5773: INTO
5774: l_rejection_id
5775: FROM
5776: DUAL
5777: ;
5778:
5779: /*
5780: * Update the terminated documents with the rejected document

Line 9410: DUAL

9406: IBY_COMPLETED_PMTS_GROUP_S.NEXTVAL
9407: INTO
9408: l_completion_id
9409: FROM
9410: DUAL
9411: ;
9412:
9413: /*
9414: * Update the completed payments for this calling app

Line 12242: DUAL

12238: 'TRUE'
12239: INTO
12240: l_test
12241: FROM
12242: DUAL
12243: WHERE
12244: EXISTS
12245: (
12246: SELECT

Line 12520: DUAL

12516: 'TRUE'
12517: INTO
12518: l_test
12519: FROM
12520: DUAL
12521: WHERE
12522: EXISTS
12523: (
12524: SELECT

Line 12637: DUAL

12633: 'TRUE'
12634: INTO
12635: l_test
12636: FROM
12637: DUAL
12638: WHERE
12639: EXISTS
12640: (
12641: SELECT

Line 12659: DUAL

12655: 'TRUE'
12656: INTO
12657: l_test
12658: FROM
12659: DUAL
12660: WHERE
12661: EXISTS
12662: (
12663: SELECT

Line 12681: DUAL

12677: 'TRUE'
12678: INTO
12679: l_test
12680: FROM
12681: DUAL
12682: WHERE
12683: EXISTS
12684: (
12685: SELECT