APPS.PAY_DK_EXPIRY_SUPPORT dependencies on PAY_PAYROLL_ACTIONS

Line 25: FROM pay_payroll_actions

21: -1, (select to_date('01/05/'|| to_char(to_number(to_char(p_date,'yyyy'))),'dd/mm/yyyy') from dual),
22: (select to_date('01/05/'|| to_char(to_number(to_char(p_date,'yyyy'))+1),'dd/mm/yyyy') from dual ))
23:
24: INTO l_return_val
25: FROM pay_payroll_actions
26: WHERE payroll_action_id = p_pactid
27: AND effective_date = p_date;
28:
29: RETURN l_return_val;