APPS.PV_EXT_ENTY_ATTR_VALUE_PVT dependencies on HZ_RELATIONSHIPS

Line 62: select orgp.party_id from hz_organization_profiles orgp, hz_relationships hz,

58:
59: x_profile_id NUMBER;
60: l_org_rec HZ_PARTY_V2PUB.organization_rec_type;
61: CURSOR c_get_party_ids (pc_entity_id IN NUMBER) IS
62: select orgp.party_id from hz_organization_profiles orgp, hz_relationships hz,
63: hz_organization_profiles orgp2 where hz.party_id = pc_entity_id and
64: hz.subject_id = orgp.party_id and hz.object_id = orgp2.party_id and orgp2.internal_flag = 'Y'
65: and orgp2.effective_end_date is null and nvl(orgp.effective_end_date, sysdate+1) > sysdate
66: ;