DBA Data[Home] [Help]

APPS.PAY_HK_MPF dependencies on PER_ALL_ASSIGNMENTS_F

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

344: END hk_quarters_val;
345:
346: /* Bug:3333006. Added the following function */
347: FUNCTION get_act_termination_date
348: (p_assignment_id in per_all_assignments_f.assignment_id%type,
349: p_date in date) RETURN date IS
350:
351: l_act_term_date date;
352:

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

349: p_date in date) RETURN date IS
350:
351: l_act_term_date date;
352:
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,