DBA Data[Home] [Help]

APPS.PAY_YEAR_END_EXTRACT dependencies on FND_DATE

Line 522: fnd_date.canonical_to_date('01-01-0001'))

518: /* find the latest td payroll transfer date - compare each of the */
519: /* assignment rows with its predecessor looking for the payroll */
520: /* that had a different tax district at that date */
521: ( select nvl(max(ASS.effective_start_date),
522: fnd_date.canonical_to_date('01-01-0001'))
523: from per_assignments_f ASS
524: ,pay_payrolls_f NROLL
525: ,hr_soft_coding_keyflex FLEX
526: ,per_assignments_f PASS /* previous assignment */