DBA Data[Home] [Help]

APPS.AR_RECEIPT_LIB_PVT dependencies on IBY_FNDCPT_PAYER_ASSGN_INSTR_V

Line 2023: from iby_fndcpt_payer_assgn_instr_v a,

2019: select distinct bb.branch_party_id "bank_branch_id",
2020: bb.BANK_ACCOUNT_ID
2021: into p_customer_bank_branch_id
2022: ,p_customer_bank_account_id
2023: from iby_fndcpt_payer_assgn_instr_v a,
2024: iby_ext_bank_accounts_v bb
2025: where a.cust_account_id = p_customer_id
2026: and a.instrument_type = 'BANKACCOUNT'
2027: and ( a.acct_site_use_id = p_customer_site_use_id or a.acct_site_use_id is null)

Line 2056: from iby_fndcpt_payer_assgn_instr_v a,

2052: select distinct bb.branch_party_id "bank_branch_id",
2053: bb.BANK_ACCOUNT_ID
2054: into p_customer_bank_branch_id,
2055: p_customer_bank_account_id
2056: from iby_fndcpt_payer_assgn_instr_v a,
2057: iby_ext_bank_accounts_v bb
2058: where a.cust_account_id = p_customer_id
2059: and a.instrument_type = 'BANKACCOUNT'
2060: and ( a.acct_site_use_id = p_customer_site_use_id or a.acct_site_use_id is null)

Line 2090: from iby_fndcpt_payer_assgn_instr_v a,

2086: select distinct bb.branch_party_id "bank_branch_id",
2087: bb.BANK_ACCOUNT_ID
2088: into p_customer_bank_branch_id
2089: ,p_customer_bank_account_id
2090: from iby_fndcpt_payer_assgn_instr_v a,
2091: iby_ext_bank_accounts_v bb
2092: where a.cust_account_id = p_customer_id
2093: and a.instrument_type = 'BANKACCOUNT'
2094: and ( a.acct_site_use_id = p_customer_site_use_id or a.acct_site_use_id is null)