eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1254: FROM PER_ALL_PEOPLE_F PAPF

1250: p_date_end DATE ) is
1251: --
1252: cursor c1 is
1253: SELECT 1
1254: FROM PER_ALL_PEOPLE_F PAPF
1255: WHERE PAPF.PERSON_ID = P_PERSON_ID
1256: AND PAPF.EFFECTIVE_START_DATE > P_DATE_END + 1 ;
1257: cursor c2 is
1258: SELECT 1

Line 1303: FROM per_all_people_f papf

1299: p_business_group_id NUMBER,
1300: P_date_end DATE) IS
1301: CURSOR c_per_changes IS
1302: SELECT 1
1303: FROM per_all_people_f papf
1304: WHERE papf.person_id = p_person_id
1305: AND papf.effective_start_date > P_date_end
1306: AND papf.business_group_id + 0 = p_business_group_id;
1307: ------

Line 1675: DELETE FROM per_all_people_f papf

1671: BEGIN
1672: -- ER FPT
1673: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'N') then
1674:
1675: DELETE FROM per_all_people_f papf
1676: WHERE papf.person_id = P_person_id
1677: AND papf.business_group_id + 0 = P_Business_group_id
1678: AND papf.effective_start_date = P_date_end + 1;
1679: --

Line 1680: UPDATE per_all_people_f papf

1676: WHERE papf.person_id = P_person_id
1677: AND papf.business_group_id + 0 = P_Business_group_id
1678: AND papf.effective_start_date = P_date_end + 1;
1679: --
1680: UPDATE per_all_people_f papf
1681: SET papf.effective_end_date = P_end_of_time
1682: , papf.last_updated_by = P_last_updated_by
1683: , papf.last_update_date = trunc(sysdate)
1684: , papf.last_update_login = P_last_update_login

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

1732: -- maintain_ppt_term --
1733: -- Purpose --
1734: -- This procedure maintains the person's record when going from an --
1735: -- applicant to an ex-applicant. --
1736: -- In particular this maintiains the person_type_id on per_all_people_f --
1737: -- by closing down the record in per_all_people_f as of the end date of --
1738: -- the person's application and inserting a row with the new person_type_id
1739: -- on the next day. --
1740: -- Arguments --

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

1733: -- Purpose --
1734: -- This procedure maintains the person's record when going from an --
1735: -- applicant to an ex-applicant. --
1736: -- In particular this maintiains the person_type_id on per_all_people_f --
1737: -- by closing down the record in per_all_people_f as of the end date of --
1738: -- the person's application and inserting a row with the new person_type_id
1739: -- on the next day. --
1740: -- Arguments --
1741: -- See below. --

Line 1753: UPDATE per_all_people_f papf

1749: P_last_updated_by NUMBER,
1750: P_last_update_login NUMBER) IS
1751: --
1752: BEGIN
1753: UPDATE per_all_people_f papf
1754: set PAPF.effective_end_date = P_date_end
1755: , PAPF.last_updated_by = P_last_updated_by
1756: , PAPF.last_update_date = trunc(sysdate)
1757: , PAPF.last_update_login = P_last_update_login

Line 1764: INSERT INTO per_all_people_f

1760: PAPF.effective_start_date AND PAPF.effective_end_date
1761: and PAPF.business_group_id + 0 = P_Business_group_id;
1762: --
1763:
1764: INSERT INTO per_all_people_f
1765: (PERSON_ID ,EFFECTIVE_START_DATE ,EFFECTIVE_END_DATE
1766: ,BUSINESS_GROUP_ID ,PERSON_TYPE_ID ,LAST_NAME
1767: ,START_DATE ,APPLICANT_NUMBER
1768: ,COMMENT_ID

Line 1999: FROM per_all_people_f PAPF,

1995: ,PAPF.LOCAL_NAME
1996: ,PAPF.GLOBAL_NAME
1997: ,PAPF.DATE_OF_DEATH
1998: -- End changes for bug 10245640
1999: FROM per_all_people_f PAPF,
2000: PER_PERSON_TYPES PPT,
2001: per_person_types PPT2
2002: WHERE PAPF.person_id = P_person_id
2003: AND PAPF.effective_end_date = P_date_end

Line 2382: l_person_id per_all_people_f.person_id%type;

2378: and ppt.system_person_type = 'EX_APL'
2379: order by ptu.effective_start_date;
2380:
2381: -- Bug 10286850
2382: l_person_id per_all_people_f.person_id%type;
2383: cursor csr_chk_emp is
2384: select asg.person_id
2385: from per_all_assignments_f asg
2386: where asg.application_id = p_application_id

Line 2442: from per_all_people_f per, per_person_types ppt

2438: and p_asg_start_date between date_received and nvl(date_end,hr_api.g_eot);
2439:
2440: cursor fpt_person_rec is
2441: select effective_start_date,effective_end_date
2442: from per_all_people_f per, per_person_types ppt
2443: where person_id = p_person_id
2444: and per.person_type_id = ppt.person_type_id
2445: and effective_start_date > p_date_received
2446: order by effective_start_date;

Line 2507: from per_all_people_f

2503: -- looping through the future PER records
2504: for per_rec in fpt_person_rec loop
2505:
2506: select min(effective_start_date) into l_effective_start_date
2507: from per_all_people_f
2508: where person_id = p_person_id
2509: and effective_start_date > p_date_received;
2510:
2511: -- Updating the current records end date

Line 2512: update per_all_people_f

2508: where person_id = p_person_id
2509: and effective_start_date > p_date_received;
2510:
2511: -- Updating the current records end date
2512: update per_all_people_f
2513: set effective_end_date = l_effective_start_date - 1
2514: where person_id = p_person_id
2515: and effective_start_date = p_date_received;
2516:

Line 2527: update per_all_people_f

2523: end if;
2524:
2525: hr_utility.set_location('Updating PER record on : '||per_rec.effective_start_date,12);
2526:
2527: update per_all_people_f
2528: set person_type_id = l_person_type_id1
2529: ,current_applicant_flag = 'Y'
2530: ,current_emp_or_apl_flag = 'Y'
2531: where person_id = p_person_id