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.PV_PARTNER_ACCNT_MGMT_PVT dependencies on HZ_CUST_SITE_USES

Line 442: FROM hz_cust_site_uses

438: )
439: IS
440: CURSOR C_site_use(l_acct_site_id NUMBER, l_site_type VARCHAR2) IS
441: SELECT site_use_id
442: FROM hz_cust_site_uses
443: WHERE cust_acct_site_id = l_acct_site_id
444: AND site_use_code = l_site_type;
445:
446: CURSOR party_site_use(l_party_site_id NUMBER, l_site_type VARCHAR2) IS

Line 937: from hz_cust_site_uses a, hz_cust_acct_sites b

933: IS
934:
935: CURSOR site_use_cur IS
936: select a.site_use_id, a.cust_acct_site_id
937: from hz_cust_site_uses a, hz_cust_acct_sites b
938: where b.cust_account_id = p_cust_account_id
939: and b.party_site_id = p_party_site_id
940: and a.cust_acct_site_id = b.cust_acct_site_id
941: and a.site_use_code = p_acct_site_type