APPS.FV_IPAC dependencies on HZ_CUST_SITE_USES

Line 102: HZ_CUST_SITE_USES rsu ,

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

Line 582: hz_cust_site_uses_all hzcsu,

578: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Customer ID = ' || transaction_rec.customer_id || ' p_bill_to_address_id = ' || p_bill_to_address_id);
579: SELECT eb.agency_location_code
580: INTO v_customer_alc
581: FROM hz_cust_acct_sites_all hzcas,
582: hz_cust_site_uses_all hzcsu,
583: iby_external_payers_all payer,
584: iby_pmt_instr_uses_all iby_ins,
585: iby_ext_bank_accounts_v eb
586: WHERE hzcas.cust_account_id = transaction_rec.customer_id