eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZP_CUST_PKG dependencies on HZ_CUST_ACCT_SITES

Line 309: from hz_cust_acct_sites acct_site,

305: BEGIN
306:
307: select site_uses.site_use_id
308: into v_statement_site_use_id
309: from hz_cust_acct_sites acct_site,
310: hz_cust_site_uses site_uses
311: where acct_site.cust_account_id = p_customer_id
312: and site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
313: and site_uses.site_use_code = 'STMTS'

Line 389: from hz_cust_acct_sites acct_site,

385: BEGIN
386:
387: select site_uses.site_use_id
388: into v_dunning_site_use_id
389: from hz_cust_acct_sites acct_site,
390: hz_cust_site_uses site_uses
391: where acct_site.cust_account_id = p_customer_id
392: and site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
393: and site_uses.site_use_code = 'DUN'

Line 467: hz_cust_acct_sites ad_cus,

463: --
464: select dls.dunning_type
465: into v_dunning_type
466: from hz_cust_site_uses su,
467: hz_cust_acct_sites ad_cus,
468: hz_customer_profiles cust_pro,
469: hz_customer_profiles site_pro,
470: ar_dunning_letter_sets dls,
471: hz_cust_accounts cus

Line 558: hz_cust_acct_sites acct_site

554: /* Bug 2625779 - declaring cursor */
555: CURSOR c_site IS
556: SELECT su.site_use_id
557: FROM hz_cust_site_uses su,
558: hz_cust_acct_sites acct_site
559: WHERE su.site_use_code = 'BILL_TO'
560: and su.cust_acct_site_id = acct_site.cust_acct_site_id
561: and acct_site.cust_account_id = p_customer_id
562: and su.primary_flag = 'Y'