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_TAP_BES_PKG dependencies on HZ_CONTACT_POINTS

Line 2135: FROM HZ_CONTACT_POINTS CP,

2131:
2132: -- Cursor l_cust_is_partner_csr.
2133: CURSOR l_cust_is_partner_csr (cv_contact_point_id NUMBER) IS
2134: SELECT /*+ index(p) */ partner_id
2135: FROM HZ_CONTACT_POINTS CP,
2136: HZ_PARTIES PARTY,
2137: pv_partner_profiles p
2138: WHERE CP.CONTACT_POINT_ID = cv_contact_Point_id
2139: AND CP.owner_table_id = p.partner_party_id

Line 2154: -- FROM HZ_CONTACT_POINTS CP,

2150: -- Commented for the bug fix # 4141409.
2151: -- SELECT /*+ index(p) */ partner_id
2152: -- FROM pv_partner_profiles p
2153: -- WHERE exists ( SELECT 'Y'
2154: -- FROM HZ_CONTACT_POINTS CP,
2155: -- HZ_PARTIES PARTY
2156: -- WHERE CP.CONTACT_POINT_ID = cv_contact_Point_id
2157: -- AND CP.owner_table_id = p.partner_party_id
2158: -- AND CP.owner_table_name(+) = 'HZ_PARTIES'