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_CUSTOMER_PROFILES

Line 456: from hz_customer_profiles prof,

452: if v_dunning_site is NOT NULL then
453: --
454: select dls.dunning_type
455: into v_dunning_type
456: from hz_customer_profiles prof,
457: ar_dunning_letter_sets dls
458: where prof.cust_account_id = p_customer_id
459: and prof.site_use_id is NULL
460: and prof.dunning_letter_set_id = dls.dunning_letter_set_id;

Line 468: hz_customer_profiles cust_pro,

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
472: where su.site_use_code = 'BILL_TO'

Line 469: hz_customer_profiles site_pro,

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
472: where su.site_use_code = 'BILL_TO'
473: and su.status = 'A'