APPS.PAY_DK_LABOR_COST_REPORT dependencies on PER_TIME_PERIODS

Line 202: per_time_periods

198: ) IS
199: SELECT
200: start_date-1 before_date
201: FROM
202: per_time_periods
203: WHERE payroll_id = p_payroll_id
204: AND to_date(to_char(p_date_of_birth,'ddmm')||p_report_year,'ddmmyyyy')
205: BETWEEN start_date AND end_date;
206: ---------------------

Line 215: per_time_periods

211: SELECT
212: min(end_date) first_end_date,
213: max(end_date) last_end_date
214: FROM
215: per_time_periods
216: WHERE payroll_id = p_payroll_id
217: AND to_char(end_date,'yyyy') = p_report_year;
218: ---------------------
219: CURSOR csr_assgid_before_change