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 1722: FROM hz_party_sites hzps,

1718:
1719: -- Cursor l_cust_is_partner_csr.
1720: CURSOR l_cust_is_partner_csr (cv_party_site_id NUMBER) IS
1721: SELECT partner_id
1722: FROM hz_party_sites hzps,
1723: pv_partner_profiles ppp
1724: WHERE hzps.party_site_id = cv_party_site_id
1725: AND hzps.status = 'A'
1726: AND ppp.partner_party_id = hzps.party_id

Line 1921: FROM hz_party_sites hps,

1917:
1918: -- Cursor l_cust_is_partner_csr.
1919: CURSOR l_cust_is_partner_csr (cv_location_id NUMBER) IS
1920: SELECT ppp.partner_id
1921: FROM hz_party_sites hps,
1922: pv_partner_profiles ppp
1923: -- Fixed the isse by pointing the LOCATION_ID to partner's party.
1924: -- WHERE ppp.partner_id = hps.party_id
1925: WHERE ppp.partner_party_id = hps.party_id