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_PARTY_SITES

Line 1551: FROM hz_party_sites hzps,

1547:
1548: -- Cursor l_cust_is_partner_csr.
1549: CURSOR l_cust_is_partner_csr (cv_party_site_id NUMBER) IS
1550: SELECT partner_id
1551: FROM hz_party_sites hzps,
1552: pv_partner_profiles ppp
1553: WHERE hzps.party_site_id = cv_party_site_id
1554: AND hzps.status = 'A'
1555: AND ppp.partner_party_id = hzps.party_id

Line 1750: FROM hz_party_sites hps,

1746:
1747: -- Cursor l_cust_is_partner_csr.
1748: CURSOR l_cust_is_partner_csr (cv_location_id NUMBER) IS
1749: SELECT ppp.partner_id
1750: FROM hz_party_sites hps,
1751: pv_partner_profiles ppp
1752: -- Fixed the isse by pointing the LOCATION_ID to partner's party.
1753: -- WHERE ppp.partner_id = hps.party_id
1754: WHERE ppp.partner_party_id = hps.party_id