APPS.PV_TERR_ASSIGN_PUB dependencies on HZ_RELATIONSHIPS

Line 766: hz_relationships HZPR_PART_CONT ,

762: -- PINAGARA Changed the code to use subquery as a fix for bug # 4869726
763: SELECT 'Y'
764: FROM
765: pv_partner_profiles PROFILE,
766: hz_relationships HZPR_PART_CONT ,
767: hz_parties CONTACT ,
768: jtf_rs_resource_extns RES
769: WHERE
770: PROFILE.partner_id = cv_partner_id

Line 4650: hz_relationships HZPR_PART_CONT ,

4646: CURSOR l_VAD_contacts_csr (cv_vad_party_id NUMBER) IS
4647: SELECT DISTINCT
4648: RES.resource_id
4649: FROM
4650: hz_relationships HZPR_PART_CONT ,
4651: hz_parties CONTACT ,
4652: jtf_rs_resource_extns RES ,
4653: jtf_rs_group_members GRPMEM,
4654: jtf_rs_group_usages GRPUSG,