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

Line 1978: , hz_relationships rel

1974: SELECT subs_prof.partner_id
1975: FROM pv_partner_profiles subs_prof
1976: , pv_partner_profiles global_prof
1977: , pv_enty_attr_values subs_enty_val
1978: , hz_relationships rel
1979: WHERE global_prof.partner_id = g_ptr_id
1980: AND global_prof.partner_party_id = rel.subject_id
1981: AND rel.relationship_type = 'PARTNER_HIERARCHY'
1982: AND rel.relationship_code = 'PARENT_OF'

Line 2522: , hz_relationships rel

2518: FROM pv_partner_profiles subs_prof
2519: , pv_partner_profiles global_prof
2520: , pv_enty_attr_values subs_enty_val
2521:
2522: , hz_relationships rel
2523: , pv_pg_memberships memb
2524: , pv_pg_enrl_requests enrq
2525: WHERE global_prof.partner_id = global_partner_id
2526: AND global_prof.partner_party_id = rel.subject_id

Line 3481: , hz_relationships rel

3477: , memb.program_id
3478: FROM pv_partner_profiles subs_prof
3479: , pv_partner_profiles global_prof
3480: , pv_enty_attr_values subs_enty_val
3481: , hz_relationships rel
3482: , pv_pg_memberships memb
3483: , pv_pg_enrl_requests enrl
3484: WHERE global_prof.partner_id = global_partner_id
3485: AND global_prof.partner_party_id = rel.subject_id