APPS.CS_WF_EVENT_PKG dependencies on PER_ALL_PEOPLE_F

Line 655: FROM PER_ALL_PEOPLE_F P

651: CS_HZ_SR_CONTACT_POINTS C
652: WHERE P.PARTY_ID = l_contact_party_id AND C.CONTACT_TYPE <> 'EMPLOYEE' AND C.PARTY_ID= P.PARTY_ID
653: UNION
654: SELECT P.FULL_NAME
655: FROM PER_ALL_PEOPLE_F P
656: WHERE P.PERSON_ID = l_contact_party_id AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(P.EFFECTIVE_START_DATE, SYSDATE))
657: AND TRUNC(NVL(P.EFFECTIVE_END_DATE, SYSDATE))
658: AND EXISTS (SELECT 1
659: FROM CS_HZ_SR_CONTACT_POINTS C

Line 672: from per_all_people_f p, cs_hz_sr_contact_points c

668: WHERE p.PARTY_ID = c.party_id and
669: c.contact_type <> 'EMPLOYEE' and c.party_id=l_contact_party_id
670: UNION
671: select p.full_name
672: from per_all_people_f p, cs_hz_sr_contact_points c
673: where p.person_id = c.party_id
674: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(p.effective_start_date, SYSDATE))
675: and TRUNC(NVL(p.effective_end_date, SYSDATE))
676: and c.contact_type = 'EMPLOYEE' and c.party_id=l_contact_party_id;

Line 700: FROM PER_ALL_PEOPLE_F P

696: AND ROWNUM <= 1;
697:
698: CURSOR l_sel_party_name_csr_emp IS
699: SELECT P.FULL_NAME
700: FROM PER_ALL_PEOPLE_F P
701: WHERE P.PERSON_ID = l_contact_party_id
702: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(P.EFFECTIVE_START_DATE, SYSDATE)) AND TRUNC(NVL(P.EFFECTIVE_END_DATE, SYSDATE))
703: AND EXISTS (SELECT 1
704: FROM CS_HZ_SR_CONTACT_POINTS C

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

1111: /************************************
1112: Roopa - begin
1113: Fix for bug 2788761
1114: contact_point_id will be hz_contact point id for contact type != employee
1115: contact_point_id will be per_all_people_f person id for contact type = employee
1116: since contact point id will be null for this contact type
1117: *************************************/
1118:
1119: IF(p_Contacts_Table(l_contact_index).CONTACT_TYPE <> 'EMPLOYEE') THEN