DBA Data[Home] [Help]

APPS.PAY_HK_MPF dependencies on PER_ASSIGNMENTS_F

Line 428: per_assignments_f ASSIGN

424: p_date in date) IS
425: SELECT target.ACTUAL_TERMINATION_DATE
426: FROM
427: per_periods_of_service target,
428: per_assignments_f ASSIGN
429: WHERE p_date BETWEEN ASSIGN.effective_start_date
430: AND ASSIGN.effective_end_date
431: AND ASSIGN.assignment_id = p_assignment_id
432: AND ASSIGN.assignment_type = 'E'