APPS.PQP_NL_PGGM_FUNCTIONS dependencies on PER_PERIODS_OF_SERVICE

Line 1202: ,per_periods_of_service pps

1198: --
1199: CURSOR c_hire_dt_cur(c_asg_id IN NUMBER) IS
1200: SELECT max(date_start)
1201: FROM per_all_assignments_f asg
1202: ,per_periods_of_service pps
1203: WHERE pps.person_id = asg.person_id
1204: AND asg.assignment_id = c_asg_id
1205: AND pps.business_group_id = p_business_group_id
1206: AND date_start <= p_date_earned;