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 2026: ,per_periods_of_service pps

2022: -- Cursor to get the hire date of the person
2023: CURSOR c_hire_dt_cur(c_asg_id IN NUMBER) IS
2024: SELECT max(date_start)
2025: FROM per_all_assignments_f asg
2026: ,per_periods_of_service pps
2027: WHERE pps.person_id = asg.person_id
2028: AND asg.assignment_id = c_asg_id
2029: AND pps.business_group_id = p_business_group_id
2030: AND date_start <= p_date_earned;

Line 3067: ,per_periods_of_service pps

3063: -- Cursor to get the hire date of the person
3064: CURSOR c_hire_dt_cur(c_asg_id IN NUMBER) IS
3065: SELECT max(date_start)
3066: FROM per_all_assignments_f asg
3067: ,per_periods_of_service pps
3068: WHERE pps.person_id = asg.person_id
3069: AND asg.assignment_id = c_asg_id
3070: AND pps.business_group_id = p_business_group_id
3071: AND date_start <= p_date_earned;

Line 4796: ,per_periods_of_service pps

4792: -- Cursor to get the hire date of the person
4793: CURSOR c_hire_dt_cur(c_asg_id IN NUMBER) IS
4794: SELECT max(date_start)
4795: FROM per_all_assignments_f asg
4796: ,per_periods_of_service pps
4797: WHERE pps.person_id = asg.person_id
4798: AND asg.assignment_id = c_asg_id
4799: AND pps.business_group_id = p_business_group_id
4800: AND date_start <= p_date_earned;