APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on FND_DATE

Line 139: l_cal_year_start := fnd_date.displaydate_to_date('01-JAN-'||to_char(l_tax_year));

135: l_tax_year := get_param_tax_year(p_bus_grp_id);
136:
137: hr_utility.set_location('get_tax_year_start',2);
138:
139: l_cal_year_start := fnd_date.displaydate_to_date('01-JAN-'||to_char(l_tax_year));
140:
141: l_tax_year_start := fnd_date.displaydate_to_date('06-APR-'||to_char(l_cal_year_start - 365, 'YYYY'));
142:
143: hr_utility.trace('Tax year start: '||to_char(l_tax_year_start,'DD-MON-YYYY'));

Line 141: l_tax_year_start := fnd_date.displaydate_to_date('06-APR-'||to_char(l_cal_year_start - 365, 'YYYY'));

137: hr_utility.set_location('get_tax_year_start',2);
138:
139: l_cal_year_start := fnd_date.displaydate_to_date('01-JAN-'||to_char(l_tax_year));
140:
141: l_tax_year_start := fnd_date.displaydate_to_date('06-APR-'||to_char(l_cal_year_start - 365, 'YYYY'));
142:
143: hr_utility.trace('Tax year start: '||to_char(l_tax_year_start,'DD-MON-YYYY'));
144: hr_utility.set_location('get_tax_year_start',99);
145:

Line 173: l_cal_year_start := fnd_date.displaydate_to_date('01-JAN-'||to_char(l_tax_year));

169: l_tax_year := get_param_tax_year(p_bus_grp_id);
170: --
171: hr_utility.set_location('get_tax_year_end',2);
172:
173: l_cal_year_start := fnd_date.displaydate_to_date('01-JAN-'||to_char(l_tax_year));
174:
175: l_tax_year_end := fnd_date.displaydate_to_date('05-APR-'||to_char(l_cal_year_start,'YYYY'));
176:
177: hr_utility.trace('Tax year end: '||to_char(l_tax_year_end,'DD-MON-YYYY'));

Line 175: l_tax_year_end := fnd_date.displaydate_to_date('05-APR-'||to_char(l_cal_year_start,'YYYY'));

171: hr_utility.set_location('get_tax_year_end',2);
172:
173: l_cal_year_start := fnd_date.displaydate_to_date('01-JAN-'||to_char(l_tax_year));
174:
175: l_tax_year_end := fnd_date.displaydate_to_date('05-APR-'||to_char(l_cal_year_start,'YYYY'));
176:
177: hr_utility.trace('Tax year end: '||to_char(l_tax_year_end,'DD-MON-YYYY'));
178: hr_utility.set_location('get_tax_year_end',99);
179:

Line 198: l_ext_end_date := fnd_date.displaydate_to_date(hruserdt.get_table_value(p_bus_group_id,

194:
195: BEGIN
196: hr_utility.set_location('get_param_ext_end_date',1);
197:
198: l_ext_end_date := fnd_date.displaydate_to_date(hruserdt.get_table_value(p_bus_group_id,
199: 'PAY GB P11D Mileage Extract',
200: 'Parameter Value',
201: 'Extract End Date (DD-MON-YYYY)',
202: ben_ext_person.g_effective_date ));

Line 975: l_ben_start_date := fnd_date.displaydate_to_date(ben_start_date(p_assignment_id));

971: l_ext_end_date := get_param_ext_end_date(l_bus_group_id);
972:
973: hr_utility.set_location('mileage_balance',6);
974:
975: l_ben_start_date := fnd_date.displaydate_to_date(ben_start_date(p_assignment_id));
976:
977: hr_utility.set_location('mileage_balance',7);
978:
979: -- fetch latest assignment action ids for that assignment as at TYE and

Line 1126: l_ben_start_date := fnd_date.displaydate_to_date(ben_start_date(p_assignment_id));

1122: l_ext_end_date := get_param_ext_end_date(l_bus_group_id);
1123:
1124: hr_utility.set_location('add_pass_balance',6);
1125:
1126: l_ben_start_date := fnd_date.displaydate_to_date(ben_start_date(p_assignment_id));
1127:
1128: hr_utility.set_location('add_pass_balance',7);
1129:
1130: -- fetch latest assignment action ids for that assignment as at TYE and