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_PRGM_APPROVAL_PVT dependencies on HZ_RELATIONSHIPS

Line 264: , hz_relationships rel

260:
261: CURSOR get_global_csr( sub_ptr_id NUMBER) IS
262: SELECT glob.partner_id
263: FROM pv_partner_profiles glob
264: , hz_relationships rel
265: , pv_partner_profiles sub
266: WHERE glob.partner_party_id= rel.object_id
267: AND rel.subject_id=sub.partner_party_id
268: AND sub.partner_id=sub_ptr_id

Line 5284: , hz_relationships rel

5280: CURSOR c_get_global_csr ( p_subs_partner_id IN NUMBER ) IS
5281: SELECT global_prof.partner_id
5282: FROM pv_partner_profiles global_prof
5283: , pv_partner_profiles subs_prof
5284: , hz_relationships rel
5285: WHERE subs_prof.partner_party_id=rel.subject_id
5286: AND rel.relationship_code = 'SUBSIDIARY_OF'
5287: AND rel.relationship_type = 'PARTNER_HIERARCHY'
5288: AND rel.status = 'A'