DBA Data[Home] [Help]

APPS.PAY_NL_EOY_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 85: from pay_payroll_actions ppa

81: --
82: CURSOR get_dp_period(c_pay_act_id NUMBER) IS
83: select ptp.start_date
84: ,ptp.end_date
85: from pay_payroll_actions ppa
86: ,per_time_periods ptp
87: where ppa.payroll_action_id = c_pay_act_id
88: AND ptp.time_period_id = ppa.time_period_id;
89: --

Line 95: ,pay_payroll_actions ppa

91: ,c_start_date DATE
92: ,c_end_date DATE) IS
93: select paa.assignment_action_id
94: from pay_assignment_actions paa
95: ,pay_payroll_actions ppa
96: where paa.assignment_id = c_assignment_id
97: and paa.payroll_action_id = ppa.payroll_action_id
98: AND ppa.action_type IN ('Q','R')
99: AND ppa.action_status in ('C','P')