548: 'EVE', ptp.end_date,
549: ptp.pay_advice_date + pay.pay_date_offset)
550: INTO l_accounting_date
551: FROM pay_all_payrolls_f pay, 552: per_time_periods ptp 553: WHERE pay.payroll_id = ecost_payroll_id
554: AND cost_effective_date BETWEEN pay.effective_start_date
555: AND pay.effective_end_date
556: AND ptp.payroll_id = pay.payroll_id