DBA Data[Home] [Help]

APPS.AR_CALC_LATE_CHARGE dependencies on HZ_CUST_ACCT_SITES

Line 740: from hz_cust_acct_sites acct_site,

736: BEGIN
737:
738: select site_uses.site_use_id
739: into l_late_charge_site_use_id
740: from hz_cust_acct_sites acct_site,
741: hz_cust_site_uses site_uses
742: where acct_site.cust_account_id = p_customer_id
743: and site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
744: and site_uses.site_use_code = 'LATE_CHARGE'

Line 869: hz_cust_acct_sites sites

865: /* Get the primary bill to site */
866: select site_use.site_use_id
867: into l_bill_to_site_use_id
868: from hz_cust_site_uses site_use,
869: hz_cust_acct_sites sites
870: where sites.cust_account_id = p_customer_id
871: and sites.bill_to_flag = 'P'
872: and sites.status ='A'
873: and sites.cust_acct_site_id = site_use.cust_acct_site_id