DBA Data[Home] [Help]

APPS.JTF_RS_IMP_RES_PVT dependencies on HZ_CONTACT_POINTS

Line 260: HZ_CONTACT_POINTS CT_POINT1

256: PARTY.PERSON_FIRST_NAME,
257: PARTY.PERSON_MIDDLE_NAME,
258: PARTY.PERSON_LAST_NAME
259: FROM HZ_PARTIES PARTY,
260: HZ_CONTACT_POINTS CT_POINT1
261: WHERE PARTY.PARTY_ID = l_person_id
262: AND PARTY.PARTY_TYPE NOT IN ('ORGANIZATION', 'GROUP')
263: AND CT_POINT1.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
264: AND CT_POINT1.OWNER_TABLE_ID (+) = PARTY.PARTY_ID

Line 310: HZ_CONTACT_POINTS CT_POINT1,

306: PARTY.PERSON_FIRST_NAME,
307: PARTY.PERSON_MIDDLE_NAME,
308: PARTY.PERSON_LAST_NAME
309: FROM HZ_PARTIES PARTY,
310: HZ_CONTACT_POINTS CT_POINT1,
311: -- HZ_PARTY_RELATIONSHIPS REL
312: HZ_RELATIONSHIPS REL
313: WHERE PARTY.PARTY_ID = l_person_id
314: AND (