DBA Data[Home] [Help]

APPS.AR_CALC_LATE_CHARGE dependencies on HZ_CUST_ACCT_SITES

Line 346: from hz_cust_acct_sites acct_site,

342: BEGIN
343:
344: select site_uses.site_use_id
345: into l_late_charge_site_use_id
346: from hz_cust_acct_sites acct_site,
347: hz_cust_site_uses site_uses
348: where acct_site.cust_account_id = p_customer_id
349: and site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
350: and site_uses.site_use_code = 'LATE_CHARGE'

Line 475: hz_cust_acct_sites sites

471: /* Get the primary bill to site */
472: select site_use.site_use_id
473: into l_bill_to_site_use_id
474: from hz_cust_site_uses site_use,
475: hz_cust_acct_sites sites
476: where sites.cust_account_id = p_customer_id
477: and sites.bill_to_flag = 'P'
478: and sites.status ='A'
479: and sites.cust_acct_site_id = site_use.cust_acct_site_id