APPS.PER_APPLICATIONS_PKG dependencies on PER_ALL_PEOPLE_F

Line 888: FROM per_all_people_f pap

884: -- application is terminated by the user or by the system while hiring
885: -- him into the Job.
886: CURSOR c_hired_emp IS
887: SELECT 1
888: FROM per_all_people_f pap
889: WHERE pap.person_id = p_person_id
890: AND pap.applicant_number IS NOT NULL
891: and EXISTS(SELECT 1 -- If hired app table has appl with end date and SUCCESSFUL_FLAG = 'Y'
892: from per_applications app

Line 1149: FROM PER_ALL_PEOPLE_F PAPF

1145: p_date_end DATE ) is
1146: --
1147: cursor c1 is
1148: SELECT 1
1149: FROM PER_ALL_PEOPLE_F PAPF
1150: WHERE PAPF.PERSON_ID = P_PERSON_ID
1151: AND PAPF.EFFECTIVE_START_DATE > P_DATE_END + 1 ;
1152: --
1153: l_dummy number ;

Line 1181: FROM per_all_people_f papf

1177: p_business_group_id NUMBER,
1178: P_date_end DATE) IS
1179: CURSOR c_per_changes IS
1180: SELECT 1
1181: FROM per_all_people_f papf
1182: WHERE papf.person_id = p_person_id
1183: AND papf.effective_start_date > P_date_end
1184: AND papf.business_group_id + 0 = p_business_group_id;
1185: ------

Line 1550: DELETE FROM per_all_people_f papf

1546: P_last_update_login NUMBER,
1547: P_end_of_time DATE) IS
1548: --
1549: BEGIN
1550: DELETE FROM per_all_people_f papf
1551: WHERE papf.person_id = P_person_id
1552: AND papf.business_group_id + 0 = P_Business_group_id
1553: AND papf.effective_start_date = P_date_end + 1;
1554: --

Line 1555: UPDATE per_all_people_f papf

1551: WHERE papf.person_id = P_person_id
1552: AND papf.business_group_id + 0 = P_Business_group_id
1553: AND papf.effective_start_date = P_date_end + 1;
1554: --
1555: UPDATE per_all_people_f papf
1556: SET papf.effective_end_date = P_end_of_time
1557: , papf.last_updated_by = P_last_updated_by
1558: , papf.last_update_date = trunc(sysdate)
1559: , papf.last_update_login = P_last_update_login

Line 1610: -- In particular this maintiains the person_type_id on per_all_people_f --

1606: -- maintain_ppt_term --
1607: -- Purpose --
1608: -- This procedure maintains the person's record when going from an --
1609: -- applicant to an ex-applicant. --
1610: -- In particular this maintiains the person_type_id on per_all_people_f --
1611: -- by closing down the record in per_all_people_f as of the end date of --
1612: -- the person's application and inserting a row with the new person_type_id
1613: -- on the next day. --
1614: -- Arguments --

Line 1611: -- by closing down the record in per_all_people_f as of the end date of --

1607: -- Purpose --
1608: -- This procedure maintains the person's record when going from an --
1609: -- applicant to an ex-applicant. --
1610: -- In particular this maintiains the person_type_id on per_all_people_f --
1611: -- by closing down the record in per_all_people_f as of the end date of --
1612: -- the person's application and inserting a row with the new person_type_id
1613: -- on the next day. --
1614: -- Arguments --
1615: -- See below. --

Line 1627: UPDATE per_all_people_f papf

1623: P_last_updated_by NUMBER,
1624: P_last_update_login NUMBER) IS
1625: --
1626: BEGIN
1627: UPDATE per_all_people_f papf
1628: set PAPF.effective_end_date = P_date_end
1629: , PAPF.last_updated_by = P_last_updated_by
1630: , PAPF.last_update_date = trunc(sysdate)
1631: , PAPF.last_update_login = P_last_update_login

Line 1638: INSERT INTO per_all_people_f

1634: PAPF.effective_start_date AND PAPF.effective_end_date
1635: and PAPF.business_group_id + 0 = P_Business_group_id;
1636: --
1637:
1638: INSERT INTO per_all_people_f
1639: (PERSON_ID ,EFFECTIVE_START_DATE ,EFFECTIVE_END_DATE
1640: ,BUSINESS_GROUP_ID ,PERSON_TYPE_ID ,LAST_NAME
1641: ,START_DATE ,APPLICANT_NUMBER
1642: ,COMMENT_ID

Line 1862: FROM per_all_people_f PAPF,

1858:
1859: --Bug2974671 ends here.
1860: ,PAPF.NPW_NUMBER -- Added for Fix for #3184546
1861:
1862: FROM per_all_people_f PAPF,
1863: PER_PERSON_TYPES PPT,
1864: per_person_types PPT2
1865: WHERE PAPF.person_id = P_person_id
1866: AND PAPF.effective_end_date = P_date_end