DBA Data[Home] [Help]

APPS.ARP_PROGRAM_BR_REMIT dependencies on IBY_PMT_INSTR_USES_ALL

Line 1517: from iby_pmt_instr_uses_all iu,

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

Line 1537: from iby_pmt_instr_uses_all iu,

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