APPS.PAY_GB_EOY dependencies on FND_DATE

Line 162: ,NVL(fnd_date.date_to_canonical(a.date_of_birth),' ')

158: SELECT SUBSTR(UPPER(a.assignment_number),1,14)
159: ,NVL(UPPER(a.last_name),' ')
160: ,UPPER(SUBSTR(a.first_name,1,7))
161: ,UPPER(a.middle_name)
162: ,NVL(fnd_date.date_to_canonical(a.date_of_birth),' ')
163: ,NVL(UPPER(a.sex),' ')
164: ,decode(a.address_line1,'','',rpad(upper(a.address_line1),27))
165: ,decode(a.address_line2,'','',rpad(upper(a.address_line2),27))
166: ,ltrim(rpad(UPPER(NVL(a.town_or_city,a.address_line3)),27))

Line 179: ,NVL(fnd_date.date_to_canonical(a.start_of_emp),' ')

175: ,decode(a.tax_refund, 'R', NVL(-1*a.tax_paid,0), NVL(a.tax_paid,0))
176: ,NVL(UPPER(a.tax_refund),' ')
177: ,NVL(a.previous_taxable_pay,0)
178: ,NVL(a.previous_tax_paid,0)
179: ,NVL(fnd_date.date_to_canonical(a.start_of_emp),' ')
180: ,fnd_date.date_to_canonical(a.termination_date)
181: ,100*(NVL(TRUNC(a.superannuation_paid/100),0))
182: ,NVL(UPPER(a.superannuation_refund),' ')
183: ,NVL(ROUND(a.widows_and_orphans/100),0)

Line 180: ,fnd_date.date_to_canonical(a.termination_date)

176: ,NVL(UPPER(a.tax_refund),' ')
177: ,NVL(a.previous_taxable_pay,0)
178: ,NVL(a.previous_tax_paid,0)
179: ,NVL(fnd_date.date_to_canonical(a.start_of_emp),' ')
180: ,fnd_date.date_to_canonical(a.termination_date)
181: ,100*(NVL(TRUNC(a.superannuation_paid/100),0))
182: ,NVL(UPPER(a.superannuation_refund),' ')
183: ,NVL(ROUND(a.widows_and_orphans/100),0)
184: ,NVL(UPPER(a.week_53_indicator),' ')

Line 654: l_local_date := FND_DATE.CANONICAL_TO_DATE(g_termination_date);

650: --
651: mag_tape_interface('DATE_OF_STARTING',g_start_of_emp);
652: BEGIN
653: IF g_termination_date IS NOT NULL THEN
654: l_local_date := FND_DATE.CANONICAL_TO_DATE(g_termination_date);
655: END IF;
656: EXCEPTION
657: WHEN value_error THEN
658: g_termination_date := '?';

Line 1167: l_local_date := FND_DATE.CANONICAL_TO_DATE(g_termination_date);

1163: --
1164: mag_tape_interface('DATE_OF_STARTING',g_start_of_emp);
1165: BEGIN
1166: IF g_termination_date IS NOT NULL THEN
1167: l_local_date := FND_DATE.CANONICAL_TO_DATE(g_termination_date);
1168: END IF;
1169: EXCEPTION
1170: WHEN value_error THEN
1171: g_termination_date := '?';