APPS.IBY_PAYMENT_FORMAT_VAL_PUB dependencies on IBY_EXT_BANK_ACCOUNTS

Line 62: iby_ext_bank_accounts ext_ba,

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
66: pmts.payment_instruction_id = p_instruction_id

Line 751: iby_ext_bank_accounts ext_ba,

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
755: pmts.payment_instruction_id = p_instruction_id

Line 1430: iby_ext_bank_accounts ext_ba,

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
1434: pmts.payment_instruction_id = p_instruction_id

Line 1789: iby_ext_bank_accounts ext_ba,

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
1793: pmts.payment_instruction_id = p_instruction_id

Line 2120: iby_ext_bank_accounts ext_ba,

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
2124: pmts.payment_instruction_id = p_instruction_id

Line 2720: iby_ext_bank_accounts ext_ba,

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
2724: pmts.payment_instruction_id = p_instruction_id

Line 3084: iby_ext_bank_accounts ext_ba,

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
3088: pmts.payment_instruction_id = p_instruction_id

Line 3443: iby_ext_bank_accounts ext_ba,

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
3447: pmts.payment_instruction_id = p_instruction_id

Line 3757: iby_ext_bank_accounts ext_ba,

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
3761: pmts.payment_instruction_id = p_instruction_id

Line 4339: iby_ext_bank_accounts ext_ba,

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
4343: pmts.payment_instruction_id = p_instruction_id

Line 4679: iby_ext_bank_accounts ext_ba,

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
4683: pmts.payment_instruction_id = p_instruction_id