DBA Data[Home] [Help]

APPS.ARP_PROGRAM_BR_REMIT dependencies on IBY_EXTERNAL_PAYERS_ALL

Line 1518: iby_external_payers_all ep,

1514: BEGIN
1515: select ep.acct_site_use_id
1516: into l_cust_acct_site_id
1517: from iby_pmt_instr_uses_all iu,
1518: iby_external_payers_all ep,
1519: iby_trxn_extensions_v iby
1520: where iby.trxn_extension_id = p_pay_trxn_extn_id
1521: and iby.instr_assignment_id = iu.instrument_payment_use_id
1522: and iu.ext_pmt_party_id = ep.ext_payer_id

Line 1538: iby_external_payers_all ep

1534: BEGIN
1535: select ep.acct_site_use_id
1536: into l_cust_acct_site_id
1537: from iby_pmt_instr_uses_all iu,
1538: iby_external_payers_all ep
1539: where iu.ext_pmt_party_id = ep.ext_payer_id
1540: and ep.cust_account_id = p_cust_account_id
1541: and iu.instrument_payment_use_id = p_instr_id
1542: and ep.acct_site_use_id IS NOT NULL