APPS.PY_ZA_PRORATE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 72: from pay_payroll_actions

68: CURSOR c2 (x_payroll_action_id number, x_assignment_id number) is
69: select effective_start_date,effective_end_date
70: from per_assignments_f
71: where payroll_id = (select payroll_id
72: from pay_payroll_actions
73: where payroll_action_id = x_payroll_action_id)
74: and assignment_id = x_assignment_id --Modified for Bug 8464020
75: order by effective_start_date;
76:

Line 102: from pay_payroll_actions

98:
99: BEGIN
100: select time_period_id
101: into x_time_period_id
102: from pay_payroll_actions
103: where payroll_action_id = x_payroll_action_id;
104:
105: exception
106: when no_data_found then

Line 115: from pay_payroll_actions

111: SELECT start_date,end_date
112: into start_date,end_date
113: from per_time_periods
114: where payroll_id = (select payroll_id
115: from pay_payroll_actions
116: where payroll_action_id = x_payroll_action_id)
117: and time_period_id = x_time_period_id;
118:
119:

Line 204: p_ppa_id IN pay_payroll_actions.payroll_action_id%TYPE

200: -- Returns the start and end dates of a period
201: -- for a payroll_action_id
202: -------------------------------------------------
203: CURSOR c_Timeperiod(
204: p_ppa_id IN pay_payroll_actions.payroll_action_id%TYPE
205: )
206: IS
207: SELECT ptp.start_date
208: , ptp.end_date

Line 210: , pay_payroll_actions ppa

206: IS
207: SELECT ptp.start_date
208: , ptp.end_date
209: FROM per_time_periods ptp
210: , pay_payroll_actions ppa
211: WHERE ppa.payroll_action_id = p_ppa_id
212: AND ptp.time_period_id = ppa.time_period_id;
213: -------------------------------------------
214: -- Cursor c_Assignment