DBA Data[Home] [Help]

APPS.PAY_NZ_CEC_REPORT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 32: pay_payroll_actions ppa

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