DBA Data[Home] [Help]

APPS.PAY_US_EMPLOYEE_BALANCES dependencies on PER_PERIODS_OF_SERVICE

Line 739: FROM per_periods_of_service pps

735:
736: IF l_date IS NOT NULL THEN
737: SELECT pps.final_process_date
738: INTO l_last_process_date
739: FROM per_periods_of_service pps
740: WHERE date_start <= p_session_date
741: AND pps.period_of_service_id = (
742: SELECT DISTINCT(period_of_service_id)
743: FROM per_all_assignments_f

Line 985: FROM per_periods_of_service pps

981:
982: IF l_date IS NOT NULL THEN
983: SELECT pps.final_process_date
984: into l_last_process_date
985: FROM per_periods_of_service pps
986: WHERE date_start <= p_session_date
987: AND pps.period_of_service_id =
988: ( SELECT DISTINCT(period_of_service_id)
989: FROM per_all_assignments_f