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 7288: SELECT start_date FROM per_previous_employers

7284: TYPE l_rec IS TABLE OF date INDEX BY binary_integer;
7285: --TYPE l_rec IS TABLE OF varchar2(50) INDEX BY binary_integer;
7286:
7287: CURSOR csr_prev_emplr_start_date(p_person_id number, p_check_start_date date,p_check_end_date date) is
7288: SELECT start_date FROM per_previous_employers
7289: WHERE person_id = p_person_id
7290: AND end_date >= p_check_start_date
7291: AND start_date <= p_check_end_date
7292: ORDER BY start_date;

Line 7295: SELECT end_date FROM per_previous_employers

7291: AND start_date <= p_check_end_date
7292: ORDER BY start_date;
7293:
7294: CURSOR csr_prev_emplr_end_date(p_person_id number, p_check_start_date date,p_check_end_date date) IS
7295: SELECT end_date FROM per_previous_employers
7296: WHERE person_id = p_person_id
7297: AND end_date >= p_check_start_date
7298: AND start_date <= p_check_end_date
7299: ORDER BY start_date;

Line 7302: SELECT min(start_date) FROM per_previous_employers

7298: AND start_date <= p_check_end_date
7299: ORDER BY start_date;
7300:
7301: CURSOR csr_get_fjob_start_date(p_person_id number, p_check_start_date date,p_check_end_date date) IS
7302: SELECT min(start_date) FROM per_previous_employers
7303: WHERE person_id = p_person_id
7304: AND end_date >= p_check_start_date
7305: AND start_date <= p_check_end_date;
7306:

Line 7308: SELECT max(end_date) FROM per_previous_employers

7304: AND end_date >= p_check_start_date
7305: AND start_date <= p_check_end_date;
7306:
7307: CURSOR csr_get_ljob_end_date(p_person_id number, p_check_start_date date,p_check_end_date date) IS
7308: SELECT max(end_date) FROM per_previous_employers
7309: WHERE person_id = p_person_id
7310: AND end_date >= p_check_start_date
7311: AND start_date <= p_check_end_date;
7312: