APPS.PAY_IN_EXC dependencies on PAY_PAYROLL_ACTIONS
Line 39: , pay_payroll_actions PACT
35: , p_date DATE
36: ) IS
37: SELECT TP.end_date + 1
38: FROM per_time_periods TP 39: , pay_payroll_actions PACT 40: WHERE PACT.payroll_action_id = p_pactid
41: AND PACT.payroll_id = TP.payroll_id
42: AND p_date BETWEEN TP.start_date AND TP.end_date;
43: