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.PATC dependencies on PER_ALL_PEOPLE_F

Line 1012: from per_all_people_f p

1008:
1009: BEGIN
1010: select p.CURRENT_EMPLOYEE_FLAG , p.CURRENT_NPW_FLAG
1011: into l_CURRENT_EMPLOYEE_FLAG , l_CURRENT_NPW_FLAG
1012: from per_all_people_f p
1013: where p.person_id = x_person_id
1014: and x_ei_date between p.effective_start_date and p.effective_end_date
1015: and ((p.current_employee_flag = 'Y') OR (p.current_npw_flag = 'Y')); -- added for bug 7395534
1016: --and p.effective_start_date <= x_ei_date

Line 1829: procedure check_termination (p_person_id in per_all_people_f.person_id%type,

1825:
1826:
1827: /* Added procedure check_termination for Bug#4604614 (BaseBug#4118885) */
1828:
1829: procedure check_termination (p_person_id in per_all_people_f.person_id%type,
1830: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,
1831: x_actual_termination_date out nocopy per_periods_of_service.actual_termination_date%type) IS
1832:
1833: cursor check_periods_of_service is

Line 1872: procedure check_termination_for_cwk (p_person_id in per_all_people_f.person_id%type,

1868:
1869: -- Bug 6156072: Base Bug 6045051: start
1870: -- Bug 6156072: Base Bug 6045051: new procedure added to check if EI Date falls between active service periods
1871: -- of the contingent worker. This is similar to procedure check_termination
1872: procedure check_termination_for_cwk (p_person_id in per_all_people_f.person_id%type,
1873: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,
1874: x_actual_termination_date out nocopy per_periods_of_placement.actual_termination_date%type) IS
1875:
1876: cursor check_periods_of_service is