APPS.PQH_SS_WORKFLOW dependencies on PER_PERIODS_OF_SERVICE

Line 817: FROM per_periods_of_service ser,

813: --
814: -- Check if assignment is terminated in future
815: CURSOR cur_fut_term_asg (c_asgnId NUMBER, c_effective_date DATE) IS
816: SELECT to_char(ser.actual_termination_date,g_date_format)
817: FROM per_periods_of_service ser,
818: per_all_assignments_f ass
819: where ass.period_of_service_id = ser.period_of_service_id
820: AND ass.assignment_id = c_asgnId
821: AND TRUNC(c_effective_date) between ass.effective_start_date AND ass.effective_end_date ;