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
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
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
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:
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
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
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
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
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
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
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
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
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
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
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
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:
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
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
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
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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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
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
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
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
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
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
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
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