APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on PER_TIME_PERIODS

Line 292: per_time_periods ptp

288: ptp.period_type,
289: substr(fnd_date.date_to_canonical(ptp.start_date),1,10) start_date,
290: substr(fnd_date.date_to_canonical(ptp.end_date),1,10) end_date
291: FROM pay_payrolls_f ppf,
292: per_time_periods ptp
293: WHERE ppf.payroll_id = ptp.payroll_id
294: AND ptp.time_period_id = p_time_period_id;
295:
296: END PAY_PAYROLL_XML_EXTRACT_PKG;