DBA Data[Home] [Help]

APPS.PAY_HK_MPF dependencies on PER_ALL_ASSIGNMENTS_F

Line 418: (p_assignment_id in per_all_assignments_f.assignment_id%type,

414: END hk_quarters_val;
415:
416: /* Bug:3333006. Added the following function */
417: FUNCTION get_act_termination_date
418: (p_assignment_id in per_all_assignments_f.assignment_id%type,
419: p_date in date) RETURN date IS
420:
421: l_act_term_date date;
422:

Line 423: CURSOR get_act_term_date(p_assignment_id in per_all_assignments_f.assignment_id%type,

419: p_date in date) RETURN date IS
420:
421: l_act_term_date date;
422:
423: CURSOR get_act_term_date(p_assignment_id in per_all_assignments_f.assignment_id%type,
424: p_date in date) IS
425: SELECT target.ACTUAL_TERMINATION_DATE
426: FROM
427: per_periods_of_service target,