DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_INT dependencies on RA_CUSTOMER_BANKS_INT_ALL

Line 4084: ra_customer_banks_int_all cbi

4080: FROM iby_external_payers_all iep,
4081: iby_pmt_instr_uses_all ipi,
4082: iby_ext_bank_accounts eba,
4083: hz_cust_accounts hca,
4084: ra_customer_banks_int_all cbi
4085: WHERE
4086: cbi.request_id = p_request_id
4087: AND eba.currency_code = cbi.bank_account_currency_code
4088: AND cbi.orig_system_customer_ref = hca.orig_system_reference

Line 4157: ra_customer_banks_int_all cbi

4153: FROM iby_external_payers_all iep,
4154: iby_pmt_instr_uses_all ipi,
4155: iby_ext_bank_accounts eba,
4156: hz_cust_accounts hca,
4157: ra_customer_banks_int_all cbi
4158: WHERE cbi.orig_system_address_ref is null
4159: AND cbi.request_id = p_request_id
4160: AND cbi.primary_flag = 'Y'
4161: AND eba.currency_code = cbi.bank_account_currency_code

Line 4182: ra_customer_banks_int_all cbi

4178: iby_ext_bank_accounts eba,
4179: hz_cust_acct_sites_all hca,
4180: hz_cust_site_uses_all hcs,
4181: hz_cust_accounts hcu,
4182: ra_customer_banks_int_all cbi
4183: WHERE cbi.request_id = p_request_id
4184: AND cbi.primary_flag = 'Y'
4185: AND cbi.orig_system_address_ref= hca.orig_system_reference
4186: AND cbi.org_id = hca.org_id