DBA Data[Home] [Help]

APPS.PAY_NL_EOY_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 77: from pay_payroll_actions ppa

73: --
74: CURSOR get_dp_period(c_pay_act_id NUMBER) IS
75: select ptp.start_date
76: ,ptp.end_date
77: from pay_payroll_actions ppa
78: ,per_time_periods ptp
79: where ppa.payroll_action_id = c_pay_act_id
80: AND ptp.time_period_id = ppa.time_period_id;
81: --

Line 87: ,pay_payroll_actions ppa

83: ,c_start_date DATE
84: ,c_end_date DATE) IS
85: select paa.assignment_action_id
86: from pay_assignment_actions paa
87: ,pay_payroll_actions ppa
88: where paa.assignment_id = c_assignment_id
89: and paa.payroll_action_id = ppa.payroll_action_id
90: AND ppa.action_type IN ('Q','R')
91: AND ppa.action_status in ('C','P')