APPS.CS_WF_EVENT_PKG dependencies on PER_ALL_PEOPLE_F

Line 374: FROM PER_ALL_PEOPLE_F P

370: CS_HZ_SR_CONTACT_POINTS C
371: WHERE P.PARTY_ID = l_contact_party_id AND C.CONTACT_TYPE <> 'EMPLOYEE' AND C.PARTY_ID= P.PARTY_ID
372: UNION
373: SELECT P.FULL_NAME
374: FROM PER_ALL_PEOPLE_F P
375: WHERE P.PERSON_ID = l_contact_party_id AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(P.EFFECTIVE_START_DATE, SYSDATE))
376: AND TRUNC(NVL(P.EFFECTIVE_END_DATE, SYSDATE))
377: AND EXISTS (SELECT 1
378: FROM CS_HZ_SR_CONTACT_POINTS C

Line 391: from per_all_people_f p, cs_hz_sr_contact_points c

387: WHERE p.PARTY_ID = c.party_id and
388: c.contact_type <> 'EMPLOYEE' and c.party_id=l_contact_party_id
389: UNION
390: select p.full_name
391: from per_all_people_f p, cs_hz_sr_contact_points c
392: where p.person_id = c.party_id
393: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(p.effective_start_date, SYSDATE))
394: and TRUNC(NVL(p.effective_end_date, SYSDATE))
395: and c.contact_type = 'EMPLOYEE' and c.party_id=l_contact_party_id;

Line 771: contact_point_id will be per_all_people_f person id for contact type = employee

767: /************************************
768: Roopa - begin
769: Fix for bug 2788761
770: contact_point_id will be hz_contact point id for contact type != employee
771: contact_point_id will be per_all_people_f person id for contact type = employee
772: since contact point id will be null for this contact type
773: *************************************/
774:
775: IF(p_Contacts_Table(l_contact_index).CONTACT_TYPE <> 'EMPLOYEE') THEN