DBA Data[Home] [Help]

APPS.PAY_NZ_CEC_REPORT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 35: pay_payroll_actions ppa

31:
32: Cursor csr_get_ass_act_id(p_assignment_id per_assignments_f.assignment_id%type,p_start_date date,p_end_date date) is
33: select paa.assignment_action_id
34: from pay_assignment_actions paa,
35: pay_payroll_actions ppa
36: where ppa.action_status ='C'
37: and ppa.action_type in ('R','Q','I','B','V')
38: and ppa.effective_date between p_start_date and p_end_date
39: and paa.payroll_action_id=ppa.payroll_action_id