DBA Data[Home] [Help]

APPS.IBY_PAYMENT_FORMAT_VAL_PUB dependencies on IBY_DOCS_PAYABLE_ALL

Line 58: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

54: FROM iby_payments_all
55: WHERE
56: payment_instruction_id = p_instruction_id;
57:
58: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
59: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
60: SELECT calling_app_doc_unique_ref2
61: FROM iby_docs_payable_all
62: WHERE

Line 59: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

55: WHERE
56: payment_instruction_id = p_instruction_id;
57:
58: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
59: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
60: SELECT calling_app_doc_unique_ref2
61: FROM iby_docs_payable_all
62: WHERE
63: payment_id = p_pmt_id

Line 61: FROM iby_docs_payable_all

57:
58: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
59: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
60: SELECT calling_app_doc_unique_ref2
61: FROM iby_docs_payable_all
62: WHERE
63: payment_id = p_pmt_id
64: AND
65: calling_app_id=200

Line 177: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

173:
174:
175:
176: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
177: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
178:
179: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
180: EXIT WHEN iby_docs_csr%NOTFOUND;
181:

Line 404: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

400: int_bank_acct_agency_loc_code
401: FROM iby_payments_all
402: WHERE payment_instruction_id = p_instruction_id;
403:
404: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
405: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
406: SELECT calling_app_doc_unique_ref2
407: FROM iby_docs_payable_all
408: WHERE

Line 405: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

401: FROM iby_payments_all
402: WHERE payment_instruction_id = p_instruction_id;
403:
404: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
405: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
406: SELECT calling_app_doc_unique_ref2
407: FROM iby_docs_payable_all
408: WHERE
409: payment_id = p_pmt_id

Line 407: FROM iby_docs_payable_all

403:
404: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
405: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
406: SELECT calling_app_doc_unique_ref2
407: FROM iby_docs_payable_all
408: WHERE
409: payment_id = p_pmt_id
410: AND
411: calling_app_id=200

Line 553: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

549:
550:
551:
552: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
553: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
554: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
555: EXIT WHEN iby_docs_csr%NOTFOUND;
556:
557: -- validate internal bank account parameters

Line 723: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

719: FROM iby_payments_all
720: WHERE
721: payment_instruction_id = p_instruction_id;
722:
723: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
724: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
725: SELECT calling_app_doc_unique_ref2
726: FROM iby_docs_payable_all
727: WHERE

Line 724: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

720: WHERE
721: payment_instruction_id = p_instruction_id;
722:
723: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
724: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
725: SELECT calling_app_doc_unique_ref2
726: FROM iby_docs_payable_all
727: WHERE
728: payment_id = p_pmt_id

Line 726: FROM iby_docs_payable_all

722:
723: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
724: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
725: SELECT calling_app_doc_unique_ref2
726: FROM iby_docs_payable_all
727: WHERE
728: payment_id = p_pmt_id
729: AND
730: calling_app_id=200

Line 854: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

850: END IF;
851:
852:
853: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
854: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
855: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
856: EXIT WHEN iby_docs_csr%NOTFOUND;
857:
858: -- validate internal bank account parameters

Line 1088: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

1084: int_bank_acct_agency_loc_code
1085: FROM iby_payments_all
1086: WHERE
1087: payment_instruction_id = p_instruction_id;
1088: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1089: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1090: SELECT calling_app_doc_unique_ref2
1091: FROM iby_docs_payable_all
1092: WHERE

Line 1089: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

1085: FROM iby_payments_all
1086: WHERE
1087: payment_instruction_id = p_instruction_id;
1088: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1089: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1090: SELECT calling_app_doc_unique_ref2
1091: FROM iby_docs_payable_all
1092: WHERE
1093: payment_id = p_pmt_id

Line 1091: FROM iby_docs_payable_all

1087: payment_instruction_id = p_instruction_id;
1088: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1089: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1090: SELECT calling_app_doc_unique_ref2
1091: FROM iby_docs_payable_all
1092: WHERE
1093: payment_id = p_pmt_id
1094: AND
1095: calling_app_id=200

Line 1233: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

1229: END IF;
1230:
1231:
1232: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
1233: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
1234: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
1235: EXIT WHEN iby_docs_csr%NOTFOUND;
1236:
1237:

Line 1387: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

1383: FROM iby_payments_all
1384: WHERE
1385: payment_instruction_id = p_instruction_id;
1386:
1387: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1388: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1389: SELECT calling_app_doc_unique_ref2
1390: FROM iby_docs_payable_all
1391: WHERE

Line 1388: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

1384: WHERE
1385: payment_instruction_id = p_instruction_id;
1386:
1387: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1388: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1389: SELECT calling_app_doc_unique_ref2
1390: FROM iby_docs_payable_all
1391: WHERE
1392: payment_id = p_pmt_id

Line 1390: FROM iby_docs_payable_all

1386:
1387: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1388: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1389: SELECT calling_app_doc_unique_ref2
1390: FROM iby_docs_payable_all
1391: WHERE
1392: payment_id = p_pmt_id
1393: AND
1394: calling_app_id=200

Line 1518: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

1514: RETURN;
1515: END IF;
1516:
1517: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
1518: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
1519: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
1520: EXIT WHEN iby_docs_csr%NOTFOUND;
1521:
1522:

Line 1730: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

1726: FROM iby_payments_all
1727: WHERE
1728: payment_instruction_id = p_instruction_id;
1729:
1730: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1731: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1732: SELECT calling_app_doc_unique_ref2
1733: FROM iby_docs_payable_all
1734: WHERE

Line 1731: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

1727: WHERE
1728: payment_instruction_id = p_instruction_id;
1729:
1730: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1731: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1732: SELECT calling_app_doc_unique_ref2
1733: FROM iby_docs_payable_all
1734: WHERE
1735: payment_id = p_pmt_id

Line 1733: FROM iby_docs_payable_all

1729:
1730: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
1731: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
1732: SELECT calling_app_doc_unique_ref2
1733: FROM iby_docs_payable_all
1734: WHERE
1735: payment_id = p_pmt_id
1736: AND
1737: calling_app_id=200

Line 1831: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

1827: END IF;
1828:
1829:
1830: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
1831: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
1832: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
1833: EXIT WHEN iby_docs_csr%NOTFOUND;
1834:
1835: -- validate internal bank account parameters

Line 2046: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

2042: FROM iby_payments_all
2043: WHERE
2044: payment_instruction_id = p_instruction_id;
2045:
2046: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2047: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2048: SELECT calling_app_doc_unique_ref2
2049: FROM iby_docs_payable_all
2050: WHERE

Line 2047: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

2043: WHERE
2044: payment_instruction_id = p_instruction_id;
2045:
2046: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2047: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2048: SELECT calling_app_doc_unique_ref2
2049: FROM iby_docs_payable_all
2050: WHERE
2051: payment_id = p_pmt_id

Line 2049: FROM iby_docs_payable_all

2045:
2046: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2047: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2048: SELECT calling_app_doc_unique_ref2
2049: FROM iby_docs_payable_all
2050: WHERE
2051: payment_id = p_pmt_id
2052: AND
2053: calling_app_id=200

Line 2146: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

2142:
2143:
2144:
2145: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
2146: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
2147: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
2148: EXIT WHEN iby_docs_csr%NOTFOUND;
2149:
2150: -- validate internal bank account parameters

Line 2352: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

2348: int_bank_acct_agency_loc_code
2349: FROM iby_payments_all
2350: WHERE payment_instruction_id = p_instruction_id;
2351:
2352: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2353: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2354: SELECT calling_app_doc_unique_ref2
2355: FROM iby_docs_payable_all
2356: WHERE

Line 2353: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

2349: FROM iby_payments_all
2350: WHERE payment_instruction_id = p_instruction_id;
2351:
2352: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2353: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2354: SELECT calling_app_doc_unique_ref2
2355: FROM iby_docs_payable_all
2356: WHERE
2357: payment_id = p_pmt_id

Line 2355: FROM iby_docs_payable_all

2351:
2352: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2353: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2354: SELECT calling_app_doc_unique_ref2
2355: FROM iby_docs_payable_all
2356: WHERE
2357: payment_id = p_pmt_id
2358: AND
2359: calling_app_id=200

Line 2482: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

2478:
2479:
2480:
2481: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
2482: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
2483: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
2484: EXIT WHEN iby_docs_csr%NOTFOUND;
2485:
2486: -- validate internal bank account parameters

Line 2621: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

2617: FROM iby_payments_all
2618: WHERE
2619: payment_instruction_id = p_instruction_id;
2620:
2621: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2622: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2623: SELECT calling_app_doc_unique_ref2
2624: FROM iby_docs_payable_all
2625: WHERE

Line 2622: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

2618: WHERE
2619: payment_instruction_id = p_instruction_id;
2620:
2621: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2622: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2623: SELECT calling_app_doc_unique_ref2
2624: FROM iby_docs_payable_all
2625: WHERE
2626: payment_id = p_pmt_id

Line 2624: FROM iby_docs_payable_all

2620:
2621: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2622: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2623: SELECT calling_app_doc_unique_ref2
2624: FROM iby_docs_payable_all
2625: WHERE
2626: payment_id = p_pmt_id
2627: AND
2628: calling_app_id=200

Line 2736: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

2732: END IF;
2733:
2734:
2735: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
2736: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
2737: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
2738: EXIT WHEN iby_docs_csr%NOTFOUND;
2739:
2740: -- validate internal bank account parameters

Line 2970: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

2966: FROM iby_payments_all
2967: WHERE
2968: payment_instruction_id = p_instruction_id;
2969:
2970: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2971: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2972: SELECT calling_app_doc_unique_ref2
2973: FROM iby_docs_payable_all
2974: WHERE

Line 2971: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

2967: WHERE
2968: payment_instruction_id = p_instruction_id;
2969:
2970: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2971: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2972: SELECT calling_app_doc_unique_ref2
2973: FROM iby_docs_payable_all
2974: WHERE
2975: payment_id = p_pmt_id

Line 2973: FROM iby_docs_payable_all

2969:
2970: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
2971: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
2972: SELECT calling_app_doc_unique_ref2
2973: FROM iby_docs_payable_all
2974: WHERE
2975: payment_id = p_pmt_id
2976: AND
2977: calling_app_id=200

Line 3086: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

3082: END IF;
3083:
3084:
3085: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
3086: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
3087: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
3088: EXIT WHEN iby_docs_csr%NOTFOUND;
3089:
3090: -- validate internal bank account parameters

Line 3314: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

3310: FROM iby_payments_all
3311: WHERE
3312: payment_instruction_id = p_instruction_id;
3313:
3314: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3315: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3316: SELECT calling_app_doc_unique_ref2
3317: FROM iby_docs_payable_all
3318: WHERE

Line 3315: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

3311: WHERE
3312: payment_instruction_id = p_instruction_id;
3313:
3314: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3315: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3316: SELECT calling_app_doc_unique_ref2
3317: FROM iby_docs_payable_all
3318: WHERE
3319: payment_id = p_pmt_id

Line 3317: FROM iby_docs_payable_all

3313:
3314: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3315: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3316: SELECT calling_app_doc_unique_ref2
3317: FROM iby_docs_payable_all
3318: WHERE
3319: payment_id = p_pmt_id
3320: AND
3321: calling_app_id=200

Line 3384: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

3380: EXIT WHEN iby_pmt_csr%NOTFOUND;
3381:
3382:
3383: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
3384: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
3385: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
3386: EXIT WHEN iby_docs_csr%NOTFOUND;
3387:
3388: -- validate internal bank account parameters

Line 3613: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

3609: FROM iby_payments_all
3610: WHERE
3611: payment_instruction_id = p_instruction_id;
3612:
3613: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3614: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3615: SELECT calling_app_doc_unique_ref2
3616: FROM iby_docs_payable_all
3617: WHERE

Line 3614: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

3610: WHERE
3611: payment_instruction_id = p_instruction_id;
3612:
3613: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3614: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3615: SELECT calling_app_doc_unique_ref2
3616: FROM iby_docs_payable_all
3617: WHERE
3618: payment_id = p_pmt_id

Line 3616: FROM iby_docs_payable_all

3612:
3613: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3614: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3615: SELECT calling_app_doc_unique_ref2
3616: FROM iby_docs_payable_all
3617: WHERE
3618: payment_id = p_pmt_id
3619: AND
3620: calling_app_id=200

Line 3682: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

3678: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
3679: EXIT WHEN iby_pmt_csr%NOTFOUND;
3680:
3681: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
3682: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
3683: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
3684: EXIT WHEN iby_docs_csr%NOTFOUND;
3685:
3686: -- validate internal bank account parameters

Line 3910: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

3906: int_bank_acct_agency_loc_code
3907: FROM iby_payments_all
3908: WHERE payment_instruction_id = p_instruction_id;
3909:
3910: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3911: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3912: SELECT calling_app_doc_unique_ref2
3913: FROM iby_docs_payable_all
3914: WHERE

Line 3911: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

3907: FROM iby_payments_all
3908: WHERE payment_instruction_id = p_instruction_id;
3909:
3910: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3911: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3912: SELECT calling_app_doc_unique_ref2
3913: FROM iby_docs_payable_all
3914: WHERE
3915: payment_id = p_pmt_id

Line 3913: FROM iby_docs_payable_all

3909:
3910: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
3911: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
3912: SELECT calling_app_doc_unique_ref2
3913: FROM iby_docs_payable_all
3914: WHERE
3915: payment_id = p_pmt_id
3916: AND
3917: calling_app_id=200

Line 4012: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

4008:
4009:
4010:
4011: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
4012: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
4013: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
4014: EXIT WHEN iby_docs_csr%NOTFOUND;
4015:
4016:

Line 4169: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

4165: FROM iby_payments_all
4166: WHERE
4167: payment_instruction_id = p_instruction_id;
4168:
4169: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
4170: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
4171: SELECT calling_app_doc_unique_ref2
4172: FROM iby_docs_payable_all
4173: WHERE

Line 4170: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

4166: WHERE
4167: payment_instruction_id = p_instruction_id;
4168:
4169: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
4170: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
4171: SELECT calling_app_doc_unique_ref2
4172: FROM iby_docs_payable_all
4173: WHERE
4174: payment_id = p_pmt_id

Line 4172: FROM iby_docs_payable_all

4168:
4169: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
4170: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
4171: SELECT calling_app_doc_unique_ref2
4172: FROM iby_docs_payable_all
4173: WHERE
4174: payment_id = p_pmt_id
4175: AND
4176: calling_app_id=200

Line 4253: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

4249: END IF;
4250:
4251:
4252: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
4253: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
4254: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
4255: EXIT WHEN iby_docs_csr%NOTFOUND;
4256:
4257: -- validate internal bank account parameters

Line 4494: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

4490: FROM iby_payments_all
4491: WHERE
4492: payment_instruction_id = p_instruction_id;
4493:
4494: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
4495: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
4496: SELECT calling_app_doc_unique_ref2
4497: FROM iby_docs_payable_all
4498: WHERE

Line 4495: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS

4491: WHERE
4492: payment_instruction_id = p_instruction_id;
4493:
4494: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
4495: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
4496: SELECT calling_app_doc_unique_ref2
4497: FROM iby_docs_payable_all
4498: WHERE
4499: payment_id = p_pmt_id

Line 4497: FROM iby_docs_payable_all

4493:
4494: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data
4495: CURSOR iby_docs_csr(p_pmt_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE) IS
4496: SELECT calling_app_doc_unique_ref2
4497: FROM iby_docs_payable_all
4498: WHERE
4499: payment_id = p_pmt_id
4500: AND
4501: calling_app_id=200

Line 4578: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL

4574: END IF;
4575:
4576:
4577: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data
4578: LOOP -- Perform Validation For Each Of record in IBY_DOCS_PAYABLE_ALL
4579: FETCH iby_docs_csr INTO l_iby_docs_rec; -- Getting Payable Documents Data
4580: EXIT WHEN iby_docs_csr%NOTFOUND;
4581:
4582: -- validate internal bank account parameters