APPS.PY_ZA_PRORATE_PKG dependencies on PER_TIME_PERIODS

Line 113: from per_time_periods

109: END;
110: BEGIN
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;

Line 209: FROM per_time_periods ptp

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