APPS.HXC_SUPERVISOR_DASHBOARD dependencies on PER_PERIODS_OF_SERVICE

Line 674: ,per_periods_of_service ppos

670: ,ppos.date_start period_start_date
671: ,NVL(ppos.actual_termination_date,hr_general.end_of_time) period_end_date
672: FROM
673: hxc_temp_tcd htt
674: ,per_periods_of_service ppos
675: WHERE (htt.period_exist = p_period_exist OR
676: htt.period_exist = lower(p_period_exist))
677: AND ppos.person_id = htt.resource_id
678: AND p_start_date > ppos.date_start