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.PAY_NO_ABSENCE dependencies on PER_PREVIOUS_EMPLOYERS

Line 157: FROM PER_PREVIOUS_EMPLOYERS

153: CURSOR child_prev_emp (personid NUMBER, stdate DATE) IS
154: SELECT START_DATE
155: ,END_DATE
156: ,fnd_number.canonical_to_number(PEM_INFORMATION1) AS PEM_INFORMATION1
157: FROM PER_PREVIOUS_EMPLOYERS
158: WHERE person_id = personid
159: AND end_date BETWEEN TO_DATE('01/01/'|| TO_CHAR(stdate,'yyyy'), 'mm/dd/yyyy' )
160: AND stdate
161: ORDER BY end_date DESC;

Line 7388: SELECT start_date FROM per_previous_employers

7384: TYPE l_rec IS TABLE OF date INDEX BY binary_integer;
7385: --TYPE l_rec IS TABLE OF varchar2(50) INDEX BY binary_integer;
7386:
7387: CURSOR csr_prev_emplr_start_date(p_person_id number, p_check_start_date date,p_check_end_date date) is
7388: SELECT start_date FROM per_previous_employers
7389: WHERE person_id = p_person_id
7390: AND end_date >= p_check_start_date
7391: AND start_date <= p_check_end_date
7392: ORDER BY start_date;

Line 7395: SELECT end_date FROM per_previous_employers

7391: AND start_date <= p_check_end_date
7392: ORDER BY start_date;
7393:
7394: CURSOR csr_prev_emplr_end_date(p_person_id number, p_check_start_date date,p_check_end_date date) IS
7395: SELECT end_date FROM per_previous_employers
7396: WHERE person_id = p_person_id
7397: AND end_date >= p_check_start_date
7398: AND start_date <= p_check_end_date
7399: ORDER BY start_date;

Line 7402: SELECT min(start_date) FROM per_previous_employers

7398: AND start_date <= p_check_end_date
7399: ORDER BY start_date;
7400:
7401: CURSOR csr_get_fjob_start_date(p_person_id number, p_check_start_date date,p_check_end_date date) IS
7402: SELECT min(start_date) FROM per_previous_employers
7403: WHERE person_id = p_person_id
7404: AND end_date >= p_check_start_date
7405: AND start_date <= p_check_end_date;
7406:

Line 7408: SELECT max(end_date) FROM per_previous_employers

7404: AND end_date >= p_check_start_date
7405: AND start_date <= p_check_end_date;
7406:
7407: CURSOR csr_get_ljob_end_date(p_person_id number, p_check_start_date date,p_check_end_date date) IS
7408: SELECT max(end_date) FROM per_previous_employers
7409: WHERE person_id = p_person_id
7410: AND end_date >= p_check_start_date
7411: AND start_date <= p_check_end_date;
7412: