[Home] [Help]
APPS.HXC_SUPERVISOR_DASHBOARD dependencies on PER_PERIODS_OF_PLACEMENT
Line 692: ,per_periods_of_placement ppos
688: ,ppos.date_start period_start_date
689: ,NVL(ppos.actual_termination_date,hr_general.end_of_time) period_end_date
690: FROM
691: hxc_temp_tcd htt
692: ,per_periods_of_placement ppos
693: WHERE (htt.period_exist = p_period_exist OR
694: htt.period_exist = lower(p_period_exist))
695: AND ppos.person_id = htt.resource_id
696: AND p_start_date > ppos.date_start