DBA Data[Home] [Help]

APPS.IBY_FNDCPT_VLD_PUB dependencies on IBY_PMT_INSTR_USES_ALL

Line 910: FROM iby_pmt_instr_uses_all uses,

906: BEGIN
907:
908: SELECT eb.iban , bbv.eft_swift_code into
909: l_iban , l_swift_code
910: FROM iby_pmt_instr_uses_all uses,
911: iby_ext_bank_accounts eb,
912: ce_bank_branches_v bbv
913: WHERE uses.instrument_id = eb.ext_bank_account_id
914: AND uses.payment_flow = 'FUNDS_CAPTURE'

Line 1141: FROM iby_pmt_instr_uses_all uses,

1137:
1138: BEGIN
1139: SELECT eb.iban , bbv.eft_swift_code into
1140: l_iban , l_swift_code
1141: FROM iby_pmt_instr_uses_all uses,
1142: iby_ext_bank_accounts eb,
1143: ce_bank_branches_v bbv
1144: WHERE uses.instrument_id = eb.ext_bank_account_id
1145: AND uses.payment_flow = 'FUNDS_CAPTURE'