DBA Data[Home] [Help]

APPS.PY_ZA_PRORATE_PKG dependencies on PER_TIME_PERIODS

Line 109: from per_time_periods

105: END;
106: BEGIN
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;

Line 205: FROM per_time_periods ptp

201: )
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: -------------------------------------------