APPS.PQH_SS_WORKFLOW dependencies on PER_PERIODS_OF_SERVICE

Line 814: FROM per_periods_of_service ser,

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