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_PENSION_FUNCTIONS dependencies on PER_PERIODS_OF_SERVICE

Line 2091: ,per_periods_of_service pps

2087: -- Cursor to get the hire date of the person
2088: CURSOR c_hire_dt_cur(c_asg_id IN NUMBER) IS
2089: SELECT max(date_start)
2090: FROM per_all_assignments_f asg
2091: ,per_periods_of_service pps
2092: WHERE pps.person_id = asg.person_id
2093: AND asg.assignment_id = c_asg_id
2094: AND pps.business_group_id = p_business_group_id
2095: AND date_start <= p_date_earned;

Line 3164: ,per_periods_of_service pps

3160: -- Cursor to get the hire date of the person
3161: CURSOR c_hire_dt_cur(c_asg_id IN NUMBER) IS
3162: SELECT max(date_start)
3163: FROM per_all_assignments_f asg
3164: ,per_periods_of_service pps
3165: WHERE pps.person_id = asg.person_id
3166: AND asg.assignment_id = c_asg_id
3167: AND pps.business_group_id = p_business_group_id
3168: AND date_start <= p_date_earned;

Line 4893: ,per_periods_of_service pps

4889: -- Cursor to get the hire date of the person
4890: CURSOR c_hire_dt_cur(c_asg_id IN NUMBER) IS
4891: SELECT max(date_start)
4892: FROM per_all_assignments_f asg
4893: ,per_periods_of_service pps
4894: WHERE pps.person_id = asg.person_id
4895: AND asg.assignment_id = c_asg_id
4896: AND pps.business_group_id = p_business_group_id
4897: AND date_start <= p_date_earned;