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_ENRQ_BINS_PVT dependencies on PV_PARTNER_PROFILES

Line 98: FROM pv_partner_profiles subs_prof

94:
95:
96: CURSOR global_id_csr(p_sub_ptr_id NUMBER) IS
97: SELECT glob_prof.partner_id
98: FROM pv_partner_profiles subs_prof
99: ,pv_partner_profiles glob_prof
100: ,hz_relationships rel
101: WHERE rel.subject_id=subs_prof.partner_party_id
102: AND rel.relationship_code = 'SUBSIDIARY_OF'

Line 99: ,pv_partner_profiles glob_prof

95:
96: CURSOR global_id_csr(p_sub_ptr_id NUMBER) IS
97: SELECT glob_prof.partner_id
98: FROM pv_partner_profiles subs_prof
99: ,pv_partner_profiles glob_prof
100: ,hz_relationships rel
101: WHERE rel.subject_id=subs_prof.partner_party_id
102: AND rel.relationship_code = 'SUBSIDIARY_OF'
103: AND rel.relationship_type = 'PARTNER_HIERARCHY'