eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_PAYMENT_FORMAT_VAL_PUB dependencies on IBY_PAYMENTS_ALL

Line 40: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

36: FROM iby_pay_instructions_all
37: WHERE
38: payment_instruction_id = p_instruction_id;
39:
40: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
41: -- Pick up Tax Payer Id/SSN from here -- Bug 5468203
42: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
43: SELECT pmts.payment_id,
44: pmts.payee_party_id,

Line 61: FROM iby_payments_all pmts,

57: ext_ba.ba_mask_setting,
58: ext_ba.ba_unmask_length) ext_bank_account_number,
59: pmts.ext_branch_number,
60: pmts.ext_bank_account_type
61: FROM iby_payments_all pmts,
62: iby_ext_bank_accounts ext_ba,
63: IBY_SYS_SECURITY_SUBKEYS baek,
64: IBY_SECURITY_SEGMENTS baes
65: WHERE

Line 168: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL

164: RETURN;
165: END IF;
166:
167: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
168: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
169:
170: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
171: EXIT WHEN iby_pmt_csr%NOTFOUND;
172:

Line 406: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

402: payment_reason_code
403: FROM iby_pay_instructions_all
404: WHERE
405: payment_instruction_id = p_instruction_id;
406: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
407: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
408: SELECT payment_id,
409: payee_party_id,
410: payee_le_registration_num,

Line 416: FROM iby_payments_all

412: payment_amount,
413: internal_bank_account_id,
414: int_bank_account_name,
415: int_bank_acct_agency_loc_code
416: FROM iby_payments_all
417: WHERE payment_instruction_id = p_instruction_id
418: AND payment_status = 'INSTRUCTION_CREATED';
419:
420: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

Line 502: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL

498: END IF;
499:
500:
501: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
502: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
503: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
504: EXIT WHEN iby_pmt_csr%NOTFOUND;
505:
506: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

Line 728: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

724: FROM iby_pay_instructions_all
725: WHERE
726: payment_instruction_id = p_instruction_id;
727:
728: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
729: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
730: SELECT pmts.payment_id,
731: pmts.payment_instruction_id,
732: pmts.payee_party_id,

Line 750: FROM iby_payments_all pmts,

746: ext_ba.ba_mask_setting,
747: ext_ba.ba_unmask_length) ext_bank_account_number,
748: pmts.ext_branch_number,
749: pmts.ext_bank_account_type
750: FROM iby_payments_all pmts,
751: iby_ext_bank_accounts ext_ba,
752: IBY_SYS_SECURITY_SUBKEYS baek,
753: IBY_SECURITY_SEGMENTS baes
754: WHERE

Line 855: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL

851:
852:
853: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
854:
855: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
856: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
857: EXIT WHEN iby_pmt_csr%NOTFOUND;
858:
859: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

Line 1114: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

1110: FROM iby_pay_instructions_all
1111: WHERE
1112: payment_instruction_id = p_instruction_id;
1113:
1114: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
1115: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1116: SELECT payment_id,
1117: payment_instruction_id,
1118: payee_party_id,

Line 1124: FROM iby_payments_all

1120: payment_amount,
1121: internal_bank_account_id,
1122: int_bank_account_name,
1123: int_bank_acct_agency_loc_code
1124: FROM iby_payments_all
1125: WHERE
1126: payment_instruction_id = p_instruction_id
1127: AND payment_status = 'INSTRUCTION_CREATED';
1128: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

Line 1222: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL

1218: RETURN;
1219: END IF;
1220:
1221: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
1222: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
1223: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
1224: EXIT WHEN iby_pmt_csr%NOTFOUND;
1225:
1226: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

Line 1407: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

1403: FROM iby_pay_instructions_all
1404: WHERE
1405: payment_instruction_id = p_instruction_id;
1406:
1407: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
1408: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1409: SELECT pmts.payment_id,
1410: pmts.payment_instruction_id,
1411: pmts.payee_party_id,

Line 1429: FROM iby_payments_all pmts,

1425: ext_ba.ba_mask_setting,
1426: ext_ba.ba_unmask_length) ext_bank_account_number,
1427: pmts.ext_branch_number,
1428: pmts.ext_bank_account_type
1429: FROM iby_payments_all pmts,
1430: iby_ext_bank_accounts ext_ba,
1431: IBY_SYS_SECURITY_SUBKEYS baek,
1432: IBY_SECURITY_SEGMENTS baes
1433: WHERE

Line 1520: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL

1516: RETURN;
1517: END IF;
1518:
1519: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
1520: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
1521: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
1522: EXIT WHEN iby_pmt_csr%NOTFOUND;
1523:
1524: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

Line 1766: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

1762: FROM iby_pay_instructions_all
1763: WHERE
1764: payment_instruction_id = p_instruction_id;
1765:
1766: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
1767: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
1768: SELECT pmts.payment_id,
1769: pmts.payment_instruction_id,
1770: pmts.payee_party_id,

Line 1788: FROM iby_payments_all pmts,

1784: ext_ba.ba_mask_setting,
1785: ext_ba.ba_unmask_length) ext_bank_account_number,
1786: pmts.ext_branch_number,
1787: pmts.ext_bank_account_type
1788: FROM iby_payments_all pmts,
1789: iby_ext_bank_accounts ext_ba,
1790: IBY_SYS_SECURITY_SUBKEYS baek,
1791: IBY_SECURITY_SEGMENTS baes
1792: WHERE

Line 1863: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL

1859: END IF;
1860:
1861:
1862: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
1863: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
1864: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
1865: EXIT WHEN iby_pmt_csr%NOTFOUND;
1866:
1867:

Line 2097: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

2093: FROM iby_pay_instructions_all
2094: WHERE
2095: payment_instruction_id = p_instruction_id;
2096:
2097: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
2098: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2099: SELECT pmts.payment_id,
2100: pmts.payment_instruction_id,
2101: pmts.payee_party_id,

Line 2119: FROM iby_payments_all pmts,

2115: ext_ba.ba_mask_setting,
2116: ext_ba.ba_unmask_length) ext_bank_account_number,
2117: pmts.ext_branch_number,
2118: pmts.ext_bank_account_type
2119: FROM iby_payments_all pmts,
2120: iby_ext_bank_accounts ext_ba,
2121: IBY_SYS_SECURITY_SUBKEYS baek,
2122: IBY_SECURITY_SEGMENTS baes
2123: WHERE

Line 2194: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL

2190: END IF;
2191:
2192:
2193: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
2194: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
2195: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
2196: EXIT WHEN iby_pmt_csr%NOTFOUND;
2197:
2198: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

Line 2426: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

2422: FROM iby_pay_instructions_all
2423: WHERE
2424: payment_instruction_id = p_instruction_id;
2425:
2426: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
2427: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2428: SELECT payment_id,
2429: payment_instruction_id,
2430: payment_amount,

Line 2434: FROM iby_payments_all

2430: payment_amount,
2431: internal_bank_account_id,
2432: int_bank_account_name,
2433: int_bank_acct_agency_loc_code
2434: FROM iby_payments_all
2435: WHERE payment_instruction_id = p_instruction_id
2436: AND payment_status = 'INSTRUCTION_CREATED';
2437:
2438: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

Line 2502: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL

2498: RETURN;
2499: END IF;
2500:
2501: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
2502: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
2503: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
2504: EXIT WHEN iby_pmt_csr%NOTFOUND;
2505:
2506: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

Line 2697: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

2693: FROM iby_pay_instructions_all
2694: WHERE
2695: payment_instruction_id = p_instruction_id;
2696:
2697: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
2698: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
2699: SELECT pmts.payment_id,
2700: pmts.payment_instruction_id,
2701: pmts.payee_party_id,

Line 2719: FROM iby_payments_all pmts,

2715: ext_ba.ba_mask_setting,
2716: ext_ba.ba_unmask_length) ext_bank_account_number,
2717: pmts.ext_branch_number,
2718: pmts.ext_bank_account_type
2719: FROM iby_payments_all pmts,
2720: iby_ext_bank_accounts ext_ba,
2721: IBY_SYS_SECURITY_SUBKEYS baek,
2722: IBY_SECURITY_SEGMENTS baes
2723: WHERE

Line 2793: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL

2789: RETURN;
2790: END IF;
2791:
2792: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
2793: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
2794: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
2795: EXIT WHEN iby_pmt_csr%NOTFOUND;
2796:
2797: IBY_PAYMENT_FORMAT_VAL_PVT.RFC_ID(l_format_name,

Line 3061: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

3057: FROM iby_pay_instructions_all
3058: WHERE
3059: payment_instruction_id = p_instruction_id;
3060:
3061: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
3062: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3063: SELECT pmts.payment_id,
3064: pmts.payment_instruction_id,
3065: pmts.payee_party_id,

Line 3083: FROM iby_payments_all pmts,

3079: ext_ba.ba_mask_setting,
3080: ext_ba.ba_unmask_length) ext_bank_account_number,
3081: pmts.ext_branch_number,
3082: pmts.ext_bank_account_type
3083: FROM iby_payments_all pmts,
3084: iby_ext_bank_accounts ext_ba,
3085: IBY_SYS_SECURITY_SUBKEYS baek,
3086: IBY_SECURITY_SEGMENTS baes
3087: WHERE

Line 3159: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL

3155: END IF;
3156:
3157:
3158: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
3159: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
3160: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
3161: EXIT WHEN iby_pmt_csr%NOTFOUND;
3162:
3163:

Line 3420: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

3416: FROM iby_pay_instructions_all
3417: WHERE
3418: payment_instruction_id = p_instruction_id;
3419:
3420: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
3421: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3422: SELECT pmts.payment_id,
3423: pmts.payment_instruction_id,
3424: pmts.payee_party_id,

Line 3442: FROM iby_payments_all pmts,

3438: ext_ba.ba_mask_setting,
3439: ext_ba.ba_unmask_length) ext_bank_account_number,
3440: pmts.ext_branch_number,
3441: pmts.ext_bank_account_type
3442: FROM iby_payments_all pmts,
3443: iby_ext_bank_accounts ext_ba,
3444: IBY_SYS_SECURITY_SUBKEYS baek,
3445: IBY_SECURITY_SEGMENTS baes
3446: WHERE

Line 3516: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL

3512: RETURN;
3513: END IF;
3514:
3515: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
3516: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
3517: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
3518: EXIT WHEN iby_pmt_csr%NOTFOUND;
3519:
3520:

Line 3734: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

3730: FROM iby_pay_instructions_all
3731: WHERE
3732: payment_instruction_id = p_instruction_id;
3733:
3734: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
3735: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
3736: SELECT pmts.payment_id,
3737: pmts.payment_instruction_id,
3738: pmts.payee_party_id,

Line 3756: FROM iby_payments_all pmts,

3752: ext_ba.ba_mask_setting,
3753: ext_ba.ba_unmask_length) ext_bank_account_number,
3754: pmts.ext_branch_number,
3755: pmts.ext_bank_account_type
3756: FROM iby_payments_all pmts,
3757: iby_ext_bank_accounts ext_ba,
3758: IBY_SYS_SECURITY_SUBKEYS baek,
3759: IBY_SECURITY_SEGMENTS baes
3760: WHERE

Line 3830: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL

3826: RETURN;
3827: END IF;
3828:
3829: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
3830: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
3831: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
3832: EXIT WHEN iby_pmt_csr%NOTFOUND;
3833:
3834: OPEN iby_docs_csr(l_iby_pmt_rec.payment_id); -- Opening Payable Documents Data

Line 4052: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

4048: FROM iby_pay_instructions_all
4049: WHERE
4050: payment_instruction_id = p_instruction_id;
4051:
4052: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
4053: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4054: SELECT payment_id,
4055: payment_instruction_id,
4056: payee_party_id,

Line 4062: FROM iby_payments_all

4058: payment_amount,
4059: internal_bank_account_id,
4060: int_bank_account_name,
4061: int_bank_acct_agency_loc_code
4062: FROM iby_payments_all
4063: WHERE payment_instruction_id = p_instruction_id
4064: AND payment_status = 'INSTRUCTION_CREATED';
4065:
4066: -- Pick Up Required Data From Payable Documents (IBY_DOCS_PAYABLE_ALL) Using Payment Id From Payment Data

Line 4130: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL

4126: RETURN;
4127: END IF;
4128:
4129: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
4130: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
4131: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
4132: EXIT WHEN iby_pmt_csr%NOTFOUND;
4133:
4134: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT at Payment Level

Line 4316: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

4312: FROM iby_pay_instructions_all
4313: WHERE
4314: payment_instruction_id = p_instruction_id;
4315:
4316: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
4317: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4318: SELECT pmts.payment_id,
4319: pmts.payment_instruction_id,
4320: pmts.payee_party_id,

Line 4338: FROM iby_payments_all pmts,

4334: ext_ba.ba_mask_setting,
4335: ext_ba.ba_unmask_length) ext_bank_account_number,
4336: pmts.ext_branch_number,
4337: pmts.ext_bank_account_type
4338: FROM iby_payments_all pmts,
4339: iby_ext_bank_accounts ext_ba,
4340: IBY_SYS_SECURITY_SUBKEYS baek,
4341: IBY_SECURITY_SEGMENTS baes
4342: WHERE

Line 4411: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL

4407: RETURN;
4408: END IF;
4409:
4410: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
4411: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
4412: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
4413: EXIT WHEN iby_pmt_csr%NOTFOUND;
4414:
4415: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level

Line 4656: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id

4652: FROM iby_pay_instructions_all
4653: WHERE
4654: payment_instruction_id = p_instruction_id;
4655:
4656: -- Pick Up Required Data From Payments (IBY_PAYMENTS_ALL) using payment_instruction_id
4657: CURSOR iby_pmt_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS
4658: SELECT pmts.payment_id,
4659: pmts.payment_instruction_id,
4660: pmts.payee_party_id,

Line 4678: FROM iby_payments_all pmts,

4674: ext_ba.ba_mask_setting,
4675: ext_ba.ba_unmask_length) ext_bank_account_number,
4676: pmts.ext_branch_number,
4677: pmts.ext_bank_account_type
4678: FROM iby_payments_all pmts,
4679: iby_ext_bank_accounts ext_ba,
4680: IBY_SYS_SECURITY_SUBKEYS baek,
4681: IBY_SECURITY_SEGMENTS baes
4682: WHERE

Line 4751: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL

4747: RETURN;
4748: END IF;
4749:
4750: OPEN iby_pmt_csr(p_instruction_id); -- Opening Payment Data Cursor
4751: LOOP -- Perform Validation For Each Of record in IBY_PAYMENTS_ALL
4752: FETCH iby_pmt_csr INTO l_iby_pmt_rec; -- Getting Payment Data
4753: EXIT WHEN iby_pmt_csr%NOTFOUND;
4754:
4755: -- Do IBY_PAYMENT_FORMAT_VAL_PVT.MAX_PAYMENT_AMT_2 at Payment Level