APPS.PV_USER_MGMT_PVT dependencies on HZ_RELATIONSHIPS

Line 52: from HZ_PARTIES PERSON_HZP, HZ_RELATIONSHIPS HZR, PV_PARTNER_PROFILES pvpp, hz_org_contacts hzoc, HZ_PARTIES ORG_HZP

48:
49:
50: cursor c_get_user_details(cv_person_rel_party_id NUMBER) IS
51: select pvpp.partner_id, pvpp.PARTNER_GROUP_ID , person_hzp.PERSON_FIRST_NAME, person_hzp.person_last_name, hzoc.org_contact_id, org_hzp.party_name
52: from HZ_PARTIES PERSON_HZP, HZ_RELATIONSHIPS HZR, PV_PARTNER_PROFILES pvpp, hz_org_contacts hzoc, HZ_PARTIES ORG_HZP
53: where HZR.party_id = cv_person_rel_party_id
54: and HZR.directional_flag = 'F'
55: and hzr.relationship_code = 'EMPLOYEE_OF'
56: and HZR.subject_table_name ='HZ_PARTIES'

Line 1983: from jtf_rs_resource_extns RES, hz_relationships hzr, pv_partner_profiles pvpp

1979: cursor cv_is_partner_user(l_rel_party_id NUMBER) IS
1980: select 1 from dual where exists
1981: (
1982: select /*+ use_nl (hzr res) */ pvpp.partner_id, hzr.party_id, hzr.subject_id ,pvpp.partner_party_id
1983: from jtf_rs_resource_extns RES, hz_relationships hzr, pv_partner_profiles pvpp
1984: where RES.category = 'PARTY' and RES.source_id = 6310
1985: and RES.start_date_active <= SYSDATE
1986: and (RES.end_date_active is null or RES.end_date_active > SYSDATE)
1987: and RES.source_id = hzr.party_id and hzr.directional_flag = 'F'