DBA Data[Home] [Help]

APPS.PAY_ES_ADVANCE_PAY dependencies on PAY_PAYROLL_ACTIONS

Line 12: FROM pay_payroll_actions

8: IS
9: --
10: CURSOR csr_pact_effective_date IS
11: SELECT effective_date
12: FROM pay_payroll_actions
13: WHERE payroll_action_id = p_payroll_action_id;
14: --
15: CURSOR csr_creator_type(p_effective_date DATE) IS
16: SELECT creator_type