APPS.HXT_HXT964A_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 10

 select  payroll_name || '   ' || to_char(ptp.start_date, 'YYYY/MM/DD') || '  -  ' || to_char(ptp.end_date, 'YYYY/MM/DD')
 into    payroll
from per_time_periods ptp, pay_payrolls_f pay
where ptp.time_period_id = P_TIME_PERIOD_ID
and (sysdate between pay.effective_start_date
    and pay.effective_end_date)
and  (ptp.payroll_id = pay.payroll_id);