eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on FND_DATE

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

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

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

142: hr_utility.set_location('get_tax_year_start',2);
143:
144: l_cal_year_start := fnd_date.displaydate_to_date('01-JAN-'||to_char(l_tax_year));
145:
146: l_tax_year_start := fnd_date.displaydate_to_date('06-APR-'||to_char(l_cal_year_start - 365, 'YYYY'));
147:
148: hr_utility.trace('Tax year start: '||to_char(l_tax_year_start,'DD-MON-YYYY'));
149: hr_utility.set_location('get_tax_year_start',99);
150:

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

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

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

176: hr_utility.set_location('get_tax_year_end',2);
177:
178: l_cal_year_start := fnd_date.displaydate_to_date('01-JAN-'||to_char(l_tax_year));
179:
180: l_tax_year_end := fnd_date.displaydate_to_date('05-APR-'||to_char(l_cal_year_start,'YYYY'));
181:
182: hr_utility.trace('Tax year end: '||to_char(l_tax_year_end,'DD-MON-YYYY'));
183: hr_utility.set_location('get_tax_year_end',99);
184:

Line 201: l_ext_start_date := fnd_date.displaydate_to_date(hruserdt.get_table_value(p_bus_group_id,

197: BEGIN
198: BEGIN
199: hr_utility.set_location('get_param_ext_start_date',1);
200:
201: l_ext_start_date := fnd_date.displaydate_to_date(hruserdt.get_table_value(p_bus_group_id,
202: 'PAY GB P11D Mileage Extract',
203: 'Parameter Value',
204: 'Extract Start Date (DD-MON-YYYY)',
205: ben_ext_person.g_effective_date ));

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

231:
232: BEGIN
233: hr_utility.set_location('get_param_ext_end_date',1);
234:
235: l_ext_end_date := fnd_date.displaydate_to_date(hruserdt.get_table_value(p_bus_group_id,
236: 'PAY GB P11D Mileage Extract',
237: 'Parameter Value',
238: 'Extract End Date (DD-MON-YYYY)',
239: ben_ext_person.g_effective_date ));

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

1010: l_ext_end_date := get_param_ext_end_date(l_bus_group_id);
1011:
1012: hr_utility.set_location('mileage_balance',6);
1013:
1014: l_ben_start_date := fnd_date.displaydate_to_date(ben_start_date(p_assignment_id));
1015:
1016: hr_utility.set_location('mileage_balance',7);
1017:
1018: -- fetch latest assignment action ids for that assignment as at TYE and

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

1161: l_ext_end_date := get_param_ext_end_date(l_bus_group_id);
1162:
1163: hr_utility.set_location('add_pass_balance',6);
1164:
1165: l_ben_start_date := fnd_date.displaydate_to_date(ben_start_date(p_assignment_id));
1166:
1167: hr_utility.set_location('add_pass_balance',7);
1168:
1169: -- fetch latest assignment action ids for that assignment as at TYE and

Line 1310: l_ben_start_date := fnd_date.displaydate_to_date(ben_start_date(p_asg_id));

1306: l_odd_even_marker := check_odd_even_year(l_tax_year_end);
1307:
1308: l_ext_end_date := get_param_ext_end_date(l_bus_group_id);
1309:
1310: l_ben_start_date := fnd_date.displaydate_to_date(ben_start_date(p_asg_id));
1311:
1312: -- fetch latest assignment action ids for that assignment as at TYE and
1313: -- extract end date (or closest asg action to either)
1314:

Line 1438: l_asg_start_date := fnd_date.displaydate_to_date(asg_start_date(p_asg_id));

1434: -- Get extract date parameter values
1435: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
1436: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
1437: -- Get Assignment Start and End Dates
1438: l_asg_start_date := fnd_date.displaydate_to_date(asg_start_date(p_asg_id));
1439: l_asg_end_date := fnd_date.displaydate_to_date(asg_end_date(p_asg_id));
1440: --
1441: OPEN get_veh_id;
1442: -- Fetch vehicle record for Car vehicle type and create extract result detail

Line 1439: l_asg_end_date := fnd_date.displaydate_to_date(asg_end_date(p_asg_id));

1435: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
1436: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
1437: -- Get Assignment Start and End Dates
1438: l_asg_start_date := fnd_date.displaydate_to_date(asg_start_date(p_asg_id));
1439: l_asg_end_date := fnd_date.displaydate_to_date(asg_end_date(p_asg_id));
1440: --
1441: OPEN get_veh_id;
1442: -- Fetch vehicle record for Car vehicle type and create extract result detail
1443:

Line 1506: l_asg_start_date := fnd_date.displaydate_to_date(asg_start_date(p_asg_id));

1502: -- Get extract date parameter values
1503: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
1504: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
1505: -- Get Assignment Start and End Dates
1506: l_asg_start_date := fnd_date.displaydate_to_date(asg_start_date(p_asg_id));
1507: l_asg_end_date := fnd_date.displaydate_to_date(asg_end_date(p_asg_id));
1508: --
1509: OPEN get_veh_id;
1510: -- Fetch vehicle record for Car vehicle type and create extract result detail

Line 1507: l_asg_end_date := fnd_date.displaydate_to_date(asg_end_date(p_asg_id));

1503: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
1504: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
1505: -- Get Assignment Start and End Dates
1506: l_asg_start_date := fnd_date.displaydate_to_date(asg_start_date(p_asg_id));
1507: l_asg_end_date := fnd_date.displaydate_to_date(asg_end_date(p_asg_id));
1508: --
1509: OPEN get_veh_id;
1510: -- Fetch vehicle record for Car vehicle type and create extract result detail
1511:

Line 1575: l_asg_start_date := fnd_date.displaydate_to_date(asg_start_date(p_asg_id));

1571: -- Get extract date parameter values
1572: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
1573: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
1574: -- Get Assignment Start and End Dates
1575: l_asg_start_date := fnd_date.displaydate_to_date(asg_start_date(p_asg_id));
1576: l_asg_end_date := fnd_date.displaydate_to_date(asg_end_date(p_asg_id));
1577: --
1578: OPEN get_veh_id;
1579: -- Fetch vehicle record for Car vehicle type and create extract result detail

Line 1576: l_asg_end_date := fnd_date.displaydate_to_date(asg_end_date(p_asg_id));

1572: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
1573: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
1574: -- Get Assignment Start and End Dates
1575: l_asg_start_date := fnd_date.displaydate_to_date(asg_start_date(p_asg_id));
1576: l_asg_end_date := fnd_date.displaydate_to_date(asg_end_date(p_asg_id));
1577: --
1578: OPEN get_veh_id;
1579: -- Fetch vehicle record for Car vehicle type and create extract result detail
1580:

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

2050:
2051: -- get params to pass to get_latest_asg_act
2052: l_ext_end_date := get_param_ext_end_date(l_bus_group_id);
2053:
2054: l_ben_start_date := fnd_date.displaydate_to_date(ben_start_date(p_assignment_id));
2055:
2056: -- fetch latest assignment action ids for that assignment as at TYE and
2057: -- extract end date (or closest asg action to either)
2058: