APPS.PY_ZA_PRORATE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 70: from pay_payroll_actions

66:
67: CURSOR c2 (x_payroll_action_id number) is select effective_start_date,effective_end_date
68: from per_assignments_f
69: where payroll_id = (select payroll_id
70: from pay_payroll_actions
71: where payroll_action_id = x_payroll_action_id)
72: and assignment_id = (select assignment_id
73: from pay_assignment_actions
74: where payroll_action_id = x_payroll_action_id)

Line 98: from pay_payroll_actions

94: x_payroll_action_id := payroll_action_id;
95: BEGIN
96: select time_period_id
97: into x_time_period_id
98: from pay_payroll_actions
99: where payroll_action_id = x_payroll_action_id;
100:
101: exception
102: when no_data_found then

Line 111: from pay_payroll_actions

107: SELECT start_date,end_date
108: into start_date,end_date
109: from per_time_periods
110: where payroll_id = (select payroll_id
111: from pay_payroll_actions
112: where payroll_action_id = x_payroll_action_id)
113: and time_period_id = x_time_period_id;
114:
115:

Line 200: p_ppa_id IN pay_payroll_actions.payroll_action_id%TYPE

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

Line 206: , pay_payroll_actions ppa

202: IS
203: SELECT ptp.start_date
204: , ptp.end_date
205: FROM per_time_periods ptp
206: , pay_payroll_actions ppa
207: WHERE ppa.payroll_action_id = p_ppa_id
208: AND ptp.time_period_id = ppa.time_period_id;
209: -------------------------------------------
210: -- Cursor c_Assignment