APPS.PA_FP_ORG_FCST_UTILS dependencies on PER_PERIODS_OF_SERVICE

Line 507: ,per_periods_of_service pps

503: CURSOR get_headcount IS
504: SELECT COUNT(*)
505: FROM per_assignments_f paf
506: ,per_all_people_f ppf
507: ,per_periods_of_service pps
508: WHERE paf.organization_id = p_organization_id
509: AND p_effective_date BETWEEN paf.effective_start_date
510: AND paf.effective_end_date
511: AND paf.assignment_type in ('E','C') /*Bug#2911451*/