APPS.FV_IPAC dependencies on HZ_CUST_SITE_USES

Line 101: HZ_CUST_SITE_USES rsu ,

97: FROM hz_parties hzp,
98: hz_cust_accounts hzca,
99: ra_customer_trx rct,
100: ra_cust_trx_types rtt,
101: HZ_CUST_SITE_USES rsu ,
102: ar_remit_to_addresses_v arem,
103: fv_facts_customers_v ffc
104: WHERE hzp.party_id = hzca.party_id
105: AND rct.bill_to_customer_id = hzca.cust_account_id

Line 595: hz_cust_site_uses_all hzcsu,

591: ' p_bill_to_address_id = ' || p_bill_to_address_id);
592: SELECT eb.agency_location_code
593: INTO v_customer_alc
594: FROM hz_cust_acct_sites_all hzcas,
595: hz_cust_site_uses_all hzcsu,
596: iby_external_payers_all payer,
597: iby_pmt_instr_uses_all iby_ins,
598: iby_ext_bank_accounts_v eb
599: WHERE hzcas.cust_account_id = transaction_rec.customer_id