DBA Data[Home] [Help]

APPS.HRI_OPL_SUPH_HST dependencies on PER_PERIODS_OF_PLACEMENT

Line 1943: per_periods_of_placement pop

1939: p_refresh_from_date) start_date
1940: ,LEAST(NVL(pop.actual_termination_date, g_end_of_time),
1941: g_end_of_time) end_date
1942: FROM
1943: per_periods_of_placement pop
1944: WHERE pop.person_id = p_person_id
1945: AND (p_refresh_from_date BETWEEN pop.date_start
1946: AND NVL(pop.actual_termination_date, g_end_of_time)
1947: OR pop.date_start > p_refresh_from_date);