DBA Data[Home] [Help]

APPS.PAY_HK_MPF dependencies on PER_PERIODS_OF_SERVICE

Line 357: per_periods_of_service target,

353: CURSOR get_act_term_date(p_assignment_id in per_all_assignments_f.assignment_id%type,
354: p_date in date) IS
355: SELECT target.ACTUAL_TERMINATION_DATE
356: FROM
357: per_periods_of_service target,
358: per_assignments_f ASSIGN
359: WHERE p_date BETWEEN ASSIGN.effective_start_date
360: AND ASSIGN.effective_end_date
361: AND ASSIGN.assignment_id = p_assignment_id