DBA Data[Home] [Help]

APPS.HRI_OPL_SUPH_HST dependencies on PER_PERIODS_OF_SERVICE

Line 1931: per_periods_of_service pos

1927: p_refresh_from_date) start_date
1928: ,LEAST(NVL(pos.actual_termination_date, g_end_of_time),
1929: g_end_of_time) end_date
1930: FROM
1931: per_periods_of_service pos
1932: WHERE pos.person_id = p_person_id
1933: AND (p_refresh_from_date BETWEEN pos.date_start
1934: AND NVL(pos.actual_termination_date, g_end_of_time)
1935: OR pos.date_start > p_refresh_from_date)