APPS.JTF_RS_IMP_RES_PVT dependencies on HZ_PARTIES

Line 259: FROM HZ_PARTIES PARTY,

255: NULL ORG_NAME,
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'

Line 263: AND CT_POINT1.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'

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
265: AND CT_POINT1.PRIMARY_FLAG (+) = 'Y'
266: AND CT_POINT1.STATUS (+) = 'A'
267: AND CT_POINT1.CONTACT_POINT_TYPE (+) = 'PHONE';

Line 280: AND hzr.subject_table_name ='HZ_PARTIES'

276: hz_org_contacts hzoc
277: WHERE hzr.party_id = l_party_id
278: AND hzr.directional_flag = 'F'
279: AND hzr.relationship_code = 'EMPLOYEE_OF'
280: AND hzr.subject_table_name ='HZ_PARTIES'
281: AND hzr.object_table_name ='HZ_PARTIES'
282: AND hzr.start_date <= SYSDATE
283: AND (hzr.end_date is null or hzr.end_date > SYSDATE)
284: AND hzr.status = 'A'

Line 281: AND hzr.object_table_name ='HZ_PARTIES'

277: WHERE hzr.party_id = l_party_id
278: AND hzr.directional_flag = 'F'
279: AND hzr.relationship_code = 'EMPLOYEE_OF'
280: AND hzr.subject_table_name ='HZ_PARTIES'
281: AND hzr.object_table_name ='HZ_PARTIES'
282: AND hzr.start_date <= SYSDATE
283: AND (hzr.end_date is null or hzr.end_date > SYSDATE)
284: AND hzr.status = 'A'
285: AND hzoc.PARTY_RELATIONSHIP_ID = hzr.relationship_id;

Line 309: FROM HZ_PARTIES PARTY,

305: PARTY.PARTY_NAME ORG_NAME,
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

Line 330: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

326: --
327: AND REL.RELATIONSHIP_CODE IN
328: ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
329: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER', 'CUSTOMER_INDIRECTLY_MANAGED_BY')
330: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
331: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
332: AND REL.DIRECTIONAL_FLAG = 'F'
333: AND REL.STATUS = 'A'
334: AND PARTY.STATUS = 'A'

Line 331: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

327: AND REL.RELATIONSHIP_CODE IN
328: ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF',
329: 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER', 'CUSTOMER_INDIRECTLY_MANAGED_BY')
330: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
331: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
332: AND REL.DIRECTIONAL_FLAG = 'F'
333: AND REL.STATUS = 'A'
334: AND PARTY.STATUS = 'A'
335: --

Line 336: AND CT_POINT1.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'

332: AND REL.DIRECTIONAL_FLAG = 'F'
333: AND REL.STATUS = 'A'
334: AND PARTY.STATUS = 'A'
335: --
336: AND CT_POINT1.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
337: AND CT_POINT1.OWNER_TABLE_ID (+) = PARTY.PARTY_ID
338: AND CT_POINT1.PRIMARY_FLAG (+) = 'Y'
339: AND CT_POINT1.STATUS (+) = 'A'
340: AND CT_POINT1.CONTACT_POINT_TYPE (+) = 'PHONE';

Line 412: hz_parties per,

408: FROM ap_suppliers P,
409: ap_supplier_contacts c,
410: ap_supplier_sites_all s,
411: hr_all_organization_units o,
412: hz_parties per,
413: hz_parties rel
414: WHERE c.vendor_contact_id = l_person_id
415: and c.vendor_site_id = s.vendor_site_id
416: and c.org_party_site_id = s.party_site_id

Line 413: hz_parties rel

409: ap_supplier_contacts c,
410: ap_supplier_sites_all s,
411: hr_all_organization_units o,
412: hz_parties per,
413: hz_parties rel
414: WHERE c.vendor_contact_id = l_person_id
415: and c.vendor_site_id = s.vendor_site_id
416: and c.org_party_site_id = s.party_site_id
417: and per.party_id = c.per_party_id