APPS.PAY_NO_EXPIRY_SUPPORT dependencies on PAY_PAYROLL_ACTIONS

Line 24: FROM pay_payroll_actions

20: SELECT TRUNC(ADD_MONTHS(p_date, DECODE(MOD(TO_CHAR(p_date, 'MM'),2),
21: 0, 1,
22: 2)), 'MM')
23: INTO l_return_val
24: FROM pay_payroll_actions
25: WHERE payroll_action_id = p_pactid
26: AND effective_date = p_date;
27:
28: RETURN l_return_val;