APPS.PAY_RETRO_PKG dependencies on FND_DATE

Line 724: l_serial_number := 'ovl='||substr(fnd_date.date_to_canonical(p_adj_start_date),1,11);

720: end loop;
721:
722: -- bug 8407213. Log earliest_overlap_date in serial_number column of pay_assignment_actions table.
723:
724: l_serial_number := 'ovl='||substr(fnd_date.date_to_canonical(p_adj_start_date),1,11);
725:
726: update pay_assignment_actions
727: set serial_number = l_serial_number
728: where assignment_action_id = p_assact;

Line 2033: set label_identifier = fnd_date.date_to_canonical(l_date)

2029:
2030: -- bug 8790029 removed if condition
2031:
2032: update pay_assignment_actions
2033: set label_identifier = fnd_date.date_to_canonical(l_date)
2034: where assignment_action_id = p_assact_id;
2035: --
2036: else
2037: --

Line 2064: set serial_number = serial_number || 'rcl=' || substr(fnd_date.date_to_canonical(v_recorded_date),1,11)

2060: -- overlap_date and recalculation_date will give an indication of the number of periods for which balance adjustmnets were
2061: -- done in place of complete retro reprocessing.
2062: --
2063: update pay_assignment_actions
2064: set serial_number = serial_number || 'rcl=' || substr(fnd_date.date_to_canonical(v_recorded_date),1,11)
2065: where assignment_action_id = p_assact_id;
2066: --
2067: hr_utility.set_location('process_recorded_date', 40);
2068: --