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.PQP_NL_ABP_FUNCTIONS dependencies on PER_PERIODS_OF_SERVICE

Line 1908: ,per_periods_of_service pps

1904: --Cursor to fetch the hire date of the employee
1905: CURSOR c_get_hire_date(c_eff_date in date) IS
1906: SELECT max(date_start)
1907: FROM per_all_assignments_f asg
1908: ,per_periods_of_service pps
1909: WHERE pps.person_id = asg.person_id
1910: AND asg.assignment_id = p_assignment_id
1911: AND pps.business_group_id = asg.business_group_id
1912: AND date_start <= c_eff_date;

Line 2866: ,per_periods_of_service pps

2862: --Cursor to fetch the hire date of the employee
2863: CURSOR c_get_hire_date(c_eff_date in date) IS
2864: SELECT max(date_start)
2865: FROM per_all_assignments_f asg
2866: ,per_periods_of_service pps
2867: WHERE pps.person_id = asg.person_id
2868: AND asg.assignment_id = p_assignment_id
2869: AND pps.business_group_id = asg.business_group_id
2870: AND date_start <= c_eff_date;

Line 6336: ,per_periods_of_service pps

6332: -- Cursor to get the hire date of the person
6333: CURSOR c_hire_dt_cur(c_asg_id IN NUMBER) IS
6334: SELECT max(date_start)
6335: FROM per_all_assignments_f asg
6336: ,per_periods_of_service pps
6337: WHERE pps.person_id = asg.person_id
6338: AND asg.assignment_id = c_asg_id
6339: AND pps.business_group_id = p_business_group_id
6340: AND date_start <= p_date_earned;