APPS.HXT_HXT964A_XMLP_PKG dependencies on PER_TIME_PERIODS

Line 12: from per_time_periods ptp, pay_payrolls_f pay

8:
9: begin
10: select payroll_name || ' ' || to_char(ptp.start_date, 'YYYY/MM/DD') || ' - ' || to_char(ptp.end_date, 'YYYY/MM/DD')
11: into payroll
12: from per_time_periods ptp, pay_payrolls_f pay
13: where ptp.time_period_id = P_TIME_PERIOD_ID
14: and (sysdate between pay.effective_start_date
15: and pay.effective_end_date)
16: and (ptp.payroll_id = pay.payroll_id);