APPS.HRFASTANSWERS dependencies on PER_PERIODS_OF_SERVICE

Line 533: from per_periods_of_service pos

529: 2, '1-3 Years',
530: 3, '3-5 Years',
531: 4, '3-5 Years',
532: '5 Years+')) service_band
533: from per_periods_of_service pos
534: , per_all_assignments_f asg
535: where asg.period_of_service_id = pos.period_of_service_id
536: and p_period_start_date-1 between asg.effective_start_date and asg.effective_end_date
537: and asg.assignment_id = p_assignment_id;