APPS.AR_RECEIPT_LIB_PVT dependencies on IBY_FNDCPT_PAYER_ASSGN_INSTR_V

Line 2016: from iby_fndcpt_payer_assgn_instr_v a,

2012: select distinct bb.branch_party_id "bank_branch_id",
2013: bb.BANK_ACCOUNT_ID
2014: into p_customer_bank_branch_id
2015: ,p_customer_bank_account_id
2016: from iby_fndcpt_payer_assgn_instr_v a,
2017: iby_ext_bank_accounts_v bb
2018: where a.cust_account_id = p_customer_id
2019: and a.instrument_type = 'BANKACCOUNT'
2020: and ( a.acct_site_use_id = p_customer_site_use_id or a.acct_site_use_id is null)

Line 2049: from iby_fndcpt_payer_assgn_instr_v a,

2045: select distinct bb.branch_party_id "bank_branch_id",
2046: bb.BANK_ACCOUNT_ID
2047: into p_customer_bank_branch_id,
2048: p_customer_bank_account_id
2049: from iby_fndcpt_payer_assgn_instr_v a,
2050: iby_ext_bank_accounts_v bb
2051: where a.cust_account_id = p_customer_id
2052: and a.instrument_type = 'BANKACCOUNT'
2053: and ( a.acct_site_use_id = p_customer_site_use_id or a.acct_site_use_id is null)

Line 2083: from iby_fndcpt_payer_assgn_instr_v a,

2079: select distinct bb.branch_party_id "bank_branch_id",
2080: bb.BANK_ACCOUNT_ID
2081: into p_customer_bank_branch_id
2082: ,p_customer_bank_account_id
2083: from iby_fndcpt_payer_assgn_instr_v a,
2084: iby_ext_bank_accounts_v bb
2085: where a.cust_account_id = p_customer_id
2086: and a.instrument_type = 'BANKACCOUNT'
2087: and ( a.acct_site_use_id = p_customer_site_use_id or a.acct_site_use_id is null)