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_HOLIDAY_PAY dependencies on PER_PREVIOUS_EMPLOYERS

Line 265: FROM per_previous_employers ppe

261: /*Bug 5344736 fix - getting the previous employer days */
262: /* Bug 5344736 fix - added condition to check the assignment start year*/
263: CURSOR csr_prev_employer_days(p_person_id NUMBER) IS
264: SELECT SUM(to_number(ppe.pem_information2))
265: FROM per_previous_employers ppe
266: WHERE ppe.business_group_id = p_business_group_id
267: AND ppe.person_id = p_person_id
268: AND to_char(ppe.end_date, 'YYYY') = to_char(p_emp_hire_date, 'YYYY')
269: AND to_char(ppe.end_date, 'YYYY') = to_char(p_asg_start_date, 'YYYY');

Line 271: l_prev_employer_days per_previous_employers.pem_information2%TYPE;

267: AND ppe.person_id = p_person_id
268: AND to_char(ppe.end_date, 'YYYY') = to_char(p_emp_hire_date, 'YYYY')
269: AND to_char(ppe.end_date, 'YYYY') = to_char(p_asg_start_date, 'YYYY');
270:
271: l_prev_employer_days per_previous_employers.pem_information2%TYPE;
272: BEGIN
273:
274: OPEN csr_person_id;
275: FETCH csr_person_id