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_CAR_EXTRACT dependencies on FND_DATE

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

37: l_ext_start_date DATE;
38: --
39: BEGIN
40: BEGIN
41: l_ext_start_date := fnd_date.displaydate_to_date(hruserdt.get_table_value(p_bus_group_id,
42: 'PAY GB P11D Car Extract',
43: 'Parameter Value',
44: 'Extract Start Date (DD-MON-YYYY)',
45: ben_ext_person.g_effective_date ));

Line 50: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))

46: EXCEPTION
47: WHEN others THEN
48: -- extract date parameter not set or wrong format
49: -- default to start of fiscal year
50: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))
51: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN
52: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date - 365, 'YYYY'));
53: ELSE
54: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));

Line 51: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN

47: WHEN others THEN
48: -- extract date parameter not set or wrong format
49: -- default to start of fiscal year
50: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))
51: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN
52: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date - 365, 'YYYY'));
53: ELSE
54: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));
55: END IF;

Line 52: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date - 365, 'YYYY'));

48: -- extract date parameter not set or wrong format
49: -- default to start of fiscal year
50: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))
51: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN
52: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date - 365, 'YYYY'));
53: ELSE
54: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));
55: END IF;
56: END;

Line 54: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));

50: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))
51: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN
52: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date - 365, 'YYYY'));
53: ELSE
54: l_ext_start_date := fnd_date.displaydate_to_date('06-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));
55: END IF;
56: END;
57: --
58: RETURN l_ext_start_date;

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

67: l_ext_end_date DATE;
68: --
69: BEGIN
70: BEGIN
71: l_ext_end_date := fnd_date.displaydate_to_date(hruserdt.get_table_value(p_bus_group_id,
72: 'PAY GB P11D Car Extract',
73: 'Parameter Value',
74: 'Extract End Date (DD-MON-YYYY)',
75: ben_ext_person.g_effective_date ));

Line 80: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))

76: EXCEPTION
77: WHEN others THEN
78: -- extract date parameter not set or wrong format
79: -- default to end of fiscal year
80: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))
81: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN
82: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));
83: ELSE
84: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date + 365, 'YYYY'));

Line 81: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN

77: WHEN others THEN
78: -- extract date parameter not set or wrong format
79: -- default to end of fiscal year
80: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))
81: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN
82: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));
83: ELSE
84: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date + 365, 'YYYY'));
85: END IF;

Line 82: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));

78: -- extract date parameter not set or wrong format
79: -- default to end of fiscal year
80: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))
81: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN
82: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));
83: ELSE
84: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date + 365, 'YYYY'));
85: END IF;
86: END;

Line 84: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date + 365, 'YYYY'));

80: IF ben_ext_person.g_effective_date BETWEEN fnd_date.displaydate_to_date('01-JAN-'||to_char(ben_ext_person.g_effective_date,'YYYY'))
81: AND fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY')) THEN
82: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date,'YYYY'));
83: ELSE
84: l_ext_end_date := fnd_date.displaydate_to_date('05-APR-'||to_char(ben_ext_person.g_effective_date + 365, 'YYYY'));
85: END IF;
86: END;
87: --
88: RETURN l_ext_end_date;

Line 481: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));

477: --
478: BEGIN
479: hr_utility.trace('Entering GET_PRIM_VIN, p_assignment_id='||p_assignment_id);
480: --
481: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
482: --
483: -- Get Vehicle Identification Number
484: OPEN get_vin;
485: FETCH get_vin INTO l_vin;

Line 516: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));

512: --
513: BEGIN
514: hr_utility.trace('Entering GET_PRIM_MAKE, p_assignment_id='||p_assignment_id);
515: --
516: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
517: --
518: -- Get make
519: OPEN get_make;
520: FETCH get_make INTO l_make;

Line 550: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));

546: --
547: BEGIN
548: hr_utility.trace('Entering GET_PRIM_MODEL, p_assignment_id='||p_assignment_id);
549: --
550: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
551: --
552: -- Get model
553: OPEN get_model;
554: FETCH get_model INTO l_model;

Line 584: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));

580: --
581: BEGIN
582: hr_utility.trace('Entering GET_PRIM_DFR, p_assignment_id='||p_assignment_id);
583: --
584: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
585: --
586: -- Get date first registered
587: OPEN get_dfr;
588: FETCH get_dfr INTO l_dfr;

Line 618: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));

614: --
615: BEGIN
616: hr_utility.trace('Entering GET_PRIM_PRICE, p_assignment_id='||p_assignment_id);
617: --
618: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
619: --
620: -- Get price
621: OPEN get_price;
622: FETCH get_price INTO l_price;

Line 667: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));

663: ORDER BY lookup_code;
664: BEGIN
665: hr_utility.trace('Entering GET_PRIM_FUEL_TYPE, p_assignment_id='||p_assignment_id);
666: --
667: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
668: --
669: -- Get fuel type
670: OPEN get_fuel_type;
671: FETCH get_fuel_type INTO l_fuel_type;

Line 707: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));

703: --
704: BEGIN
705: hr_utility.trace('Entering GET_PRIM_CO2_EMI, p_assignment_id='||p_assignment_id);
706: --
707: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
708: --
709: -- Get CO2 Emissions
710: OPEN get_co2_emi;
711: FETCH get_co2_emi INTO l_co2_emi;

Line 742: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));

738: --
739: BEGIN
740: hr_utility.trace('Entering GET_PRIM_OPTIONAL_ACC, p_assignment_id='||p_assignment_id);
741: --
742: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
743: --
744: -- Get accessory value
745: OPEN get_opt_acc;
746: FETCH get_opt_acc INTO l_opt_acc;

Line 776: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));

772: --
773: BEGIN
774: hr_utility.trace('Entering GET_PRIM_ACC_ADDED_AFTER, p_assignment_id='||p_assignment_id);
775: --
776: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
777: --
778: -- Get accessory value added later
779: OPEN get_acc_added;
780: FETCH get_acc_added INTO l_acc_added;

Line 808: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));

804: --
805: BEGIN
806: hr_utility.trace('Entering GET_PRIM_CAPITAL_CONTRIB, p_assignment_id='||p_assignment_id);
807: --
808: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
809: --
810: -- Get Capital Contribution
811: OPEN get_cap_contrib;
812: FETCH get_cap_contrib INTO l_cap_contrib;

Line 841: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));

837: --
838: BEGIN
839: hr_utility.trace('Entering GET_PRIM_PRIVATE_CONTRIB, p_assignment_id='||p_assignment_id);
840: --
841: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
842: --
843: -- Get Private Contribution
844: OPEN get_pri_contrib;
845: FETCH get_pri_contrib INTO l_pri_contrib;

Line 876: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));

872: --
873: BEGIN
874: hr_utility.trace('Entering GET_PRIM_ENGINE_CAPACITY, p_assignment_id='||p_assignment_id);
875: --
876: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
877: --
878: -- Get Engine Capacity
879: OPEN get_engine_cap;
880: FETCH get_engine_cap INTO l_engine_cap;

Line 909: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));

905: --
906: BEGIN
907: hr_utility.trace('Entering GET_PRIM_FUEL_BENEFIT, p_assignment_id='||p_assignment_id);
908: --
909: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
910: --
911: -- Get Fuel Benefit Flag
912: OPEN get_fuel_benefit;
913: FETCH get_fuel_benefit INTO l_fuel_benefit;

Line 942: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));

938: --
939: BEGIN
940: hr_utility.trace('Entering GET_PRIM_VEHICLE_DETAILS_ID, p_assignment_id='||p_assignment_id);
941: --
942: l_ben_start_date := fnd_date.displaydate_to_date(get_prim_ben_start_date(p_assignment_id));
943: --
944: hr_utility.trace('GET_PRIM_VEHICLE_DETAILS_ID: l_ben_start_date='||to_char(l_ben_start_date, 'DD-MON-YYYY'));
945: --
946: -- Get Vehicle Details Id

Line 1016: AND l_ext_start_date < fnd_date.canonical_to_date('2003/04/06') -- BUG 3431106 Using canonical_to_date function

1012: WHERE paa.assignment_id = p_asg_id
1013: AND paa.effective_start_date <= l_ext_end_date
1014: AND paa.effective_end_date >= l_ext_start_date
1015: AND (paa.primary_company_car IS NOT NULL OR paa.secondary_company_car IS NOT NULL)
1016: AND l_ext_start_date < fnd_date.canonical_to_date('2003/04/06') -- BUG 3431106 Using canonical_to_date function
1017: UNION
1018: SELECT 'Y' vehicle_exist_flag
1019: FROM pqp_vehicle_allocations_f paaf,
1020: pqp_vehicle_repository_f pvd

Line 1028: AND l_ext_start_date >= fnd_date.canonical_to_date('2003/04/06'); -- BUG 3431106 Using canonical_to_date function

1024: AND paaf.vehicle_repository_id IS NOT NULL
1025: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id
1026: AND pvd.vehicle_type = 'C'
1027: AND pvd.vehicle_ownership = 'C'
1028: AND l_ext_start_date >= fnd_date.canonical_to_date('2003/04/06'); -- BUG 3431106 Using canonical_to_date function
1029: BEGIN
1030: hr_utility.trace('Entering CHECK_ASG_INCLUSION, p_assignment_id='||p_assignment_id);
1031: -- Get Business Group Id
1032: l_bus_group_id := get_bus_group_id(p_assignment_id);

Line 1310: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));

1306: -- Get extract date parameter values
1307: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
1308: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
1309: -- Get Assignment Start and End Dates
1310: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));
1311: l_asg_end_date := fnd_date.displaydate_to_date(get_prim_asg_end_date(p_asg_id));
1312: --
1313: OPEN get_veh_id;
1314: -- Loop through all vehicle records and create extract result detail

Line 1311: l_asg_end_date := fnd_date.displaydate_to_date(get_prim_asg_end_date(p_asg_id));

1307: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
1308: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
1309: -- Get Assignment Start and End Dates
1310: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));
1311: l_asg_end_date := fnd_date.displaydate_to_date(get_prim_asg_end_date(p_asg_id));
1312: --
1313: OPEN get_veh_id;
1314: -- Loop through all vehicle records and create extract result detail
1315: -- record if there is a change in primary_car_fuel_benifit or vehicle id

Line 1409: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));

1405: -- Get extract date parameter values
1406: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
1407: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
1408: -- Get Assignment Start and End Dates
1409: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));
1410: l_asg_end_date := fnd_date.displaydate_to_date(get_prim_asg_end_date(p_asg_id));
1411: --
1412: OPEN get_veh_id;
1413: -- Loop through all vehicle records and create extract result detail

Line 1410: l_asg_end_date := fnd_date.displaydate_to_date(get_prim_asg_end_date(p_asg_id));

1406: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
1407: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
1408: -- Get Assignment Start and End Dates
1409: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));
1410: l_asg_end_date := fnd_date.displaydate_to_date(get_prim_asg_end_date(p_asg_id));
1411: --
1412: OPEN get_veh_id;
1413: -- Loop through all vehicle records and create extract result detail
1414: -- record if there is a change in secondary_car_fuel_benefit or vehicle id

Line 1736: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

1732: --
1733: BEGIN
1734: hr_utility.trace('Entering get_prim_ben_end_date, p_assignment_id='||p_assignment_id);
1735: --
1736: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
1737: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
1738: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
1739: --
1740: -- Get benefit details

Line 1781: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

1777: --
1778: BEGIN
1779: hr_utility.trace('Entering GET_PRIM_VIN, p_assignment_id='||p_assignment_id);
1780: --
1781: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
1782: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
1783: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
1784: --
1785: -- Get Vehicle Identification Number

Line 1824: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

1820: --
1821: BEGIN
1822: hr_utility.trace('Entering PRIM_MAKE, p_assignment_id='||p_assignment_id);
1823: --
1824: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
1825: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
1826: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
1827: --
1828: -- Get make

Line 1866: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

1862: --
1863: BEGIN
1864: hr_utility.trace('Entering PRIM_MODEL, p_assignment_id='||p_assignment_id);
1865: --
1866: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
1867: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
1868: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
1869: --
1870: -- Get model

Line 1908: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

1904: --
1905: BEGIN
1906: hr_utility.trace('Entering PRIM_DFR, p_assignment_id='||p_assignment_id);
1907: --
1908: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
1909: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
1910: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
1911: --
1912: -- Get date first registered

Line 1950: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

1946: --
1947: BEGIN
1948: hr_utility.trace('Entering PRIM_PRICE, p_assignment_id='||p_assignment_id);
1949: --
1950: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
1951: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
1952: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
1953: --
1954: -- Get price

Line 2008: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

2004: ORDER BY lookup_code;
2005: BEGIN
2006: hr_utility.trace('Entering PRIM_FUEL_TYPE, p_assignment_id='||p_assignment_id);
2007: --
2008: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2009: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2010: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
2011: --
2012: -- Get fuel type

Line 2056: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

2052: --
2053: BEGIN
2054: hr_utility.trace('Entering PRIM_CO2_EMI, p_assignment_id='||p_assignment_id);
2055: --
2056: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2057: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2058: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
2059: --
2060: -- Get CO2 Emissions

Line 2102: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

2098: --
2099: BEGIN
2100: hr_utility.trace('Entering PRIM_OPTIONAL_ACC, p_assignment_id='||p_assignment_id);
2101: --
2102: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2103: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2104: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
2105: --
2106: -- Get accessory value

Line 2144: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

2140: --
2141: BEGIN
2142: hr_utility.trace('Entering PRIM_CAPITAL_CONTRIB, p_assignment_id='||p_assignment_id);
2143: --
2144: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2145: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2146: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
2147: --
2148: -- Get Capital Contribution

Line 2187: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

2183: --
2184: BEGIN
2185: hr_utility.trace('Entering PRIM_PRIVATE_CONTRIB, p_assignment_id='||p_assignment_id);
2186: --
2187: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2188: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2189: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
2190: --
2191: -- Get Private Contribution

Line 2229: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

2225: --
2226: BEGIN
2227: hr_utility.trace('Entering PRIM_ENGINE_CAPACITY, p_assignment_id='||p_assignment_id);
2228: --
2229: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2230: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2231: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
2232: --
2233: -- Get Engine Capacity

Line 2271: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

2267: --
2268: BEGIN
2269: hr_utility.trace('Entering PRIM_FUEL_BENEFIT, p_assignment_id='||p_assignment_id);
2270: --
2271: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2272: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2273: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
2274: --
2275: -- Get Fuel Benefit Flag

Line 2314: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

2310: hr_utility.trace('Entering PRIM_FUEL_REINSTATED, p_assignment_id='||p_assignment_id);
2311: --
2312: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2313: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
2314: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2315: --
2316: -- Get make
2317: OPEN get_fuel_reinstated;
2318: FETCH get_fuel_reinstated INTO l_fuel;

Line 2364: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

2360: --
2361: BEGIN
2362: hr_utility.trace('Entering PRIM_FREE_FUEL_WITHDRAWN, p_assignment_id='||p_assignment_id);
2363: --
2364: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2365: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2366: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
2367: --
2368: -- Get make

Line 2419: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

2415:
2416: BEGIN
2417: hr_utility.trace('Entering PRIM_ADDITIONAL_FUEL_DAYS , p_assignment_id='||p_assignment_id);
2418: --
2419: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2420: --
2421: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2422: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
2423: l_start_date := fnd_date.displaydate_to_date(prim_free_fuel_withdrawn(p_assignment_id));

Line 2423: l_start_date := fnd_date.displaydate_to_date(prim_free_fuel_withdrawn(p_assignment_id));

2419: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2420: --
2421: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2422: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
2423: l_start_date := fnd_date.displaydate_to_date(prim_free_fuel_withdrawn(p_assignment_id));
2424: --
2425: if l_start_date is null then
2426: l_days := null;
2427: ELSE

Line 2477: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

2473: hr_utility.trace('Entering PRIM_FUEL_REINSTATED, p_assignment_id='||p_assignment_id);
2474: --
2475: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2476: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
2477: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2478: --
2479: -- Get make
2480: OPEN get_fuel_reinstated;
2481: FETCH get_fuel_reinstated INTO l_fuel;

Line 2529: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

2525: --
2526: BEGIN
2527: hr_utility.trace('Entering PRIM_FREE_FUEL_WITHDRAWN, p_assignment_id='||p_assignment_id);
2528: --
2529: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2530: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2531: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
2532: --
2533: -- Get make

Line 2586: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));

2582:
2583: BEGIN
2584: hr_utility.trace('Entering PRIM_ADDITIONAL_FUEL_DAYS , p_assignment_id='||p_assignment_id);
2585: --
2586: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2587: --
2588: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2589: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
2590: l_start_date := fnd_date.displaydate_to_date(prim_free_fuel_withdrawn(p_assignment_id));

Line 2590: l_start_date := fnd_date.displaydate_to_date(prim_free_fuel_withdrawn(p_assignment_id));

2586: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_assignment_id));
2587: --
2588: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));
2589: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
2590: l_start_date := fnd_date.displaydate_to_date(prim_free_fuel_withdrawn(p_assignment_id));
2591: --
2592: if l_start_date is null then
2593: l_days := null;
2594: ELSE

Line 2744: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));

2740: -- Call API to create extract details record
2741: BEGIN
2742: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: Insert result details.');
2743: /* added below variables for bug 6154257 */
2744: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));
2745: l_asg_end_date := fnd_date.displaydate_to_date(get_prim_asg_end_date(p_asg_id));
2746: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
2747: ,p_ext_rslt_id => g_ext_rslt_id
2748: ,p_ext_rcd_id => g_veh_rcd_id

Line 2745: l_asg_end_date := fnd_date.displaydate_to_date(get_prim_asg_end_date(p_asg_id));

2741: BEGIN
2742: hr_utility.trace('CREATE_EXT_RSLT_DTL_04: Insert result details.');
2743: /* added below variables for bug 6154257 */
2744: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));
2745: l_asg_end_date := fnd_date.displaydate_to_date(get_prim_asg_end_date(p_asg_id));
2746: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
2747: ,p_ext_rslt_id => g_ext_rslt_id
2748: ,p_ext_rcd_id => g_veh_rcd_id
2749: ,p_person_id => g_person_id

Line 2853: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_asg_id));

2849:
2850: BEGIN
2851: hr_utility.trace('Entering PROCESS_SEC_VEH_NEW, p_asg_id='||p_asg_id);
2852: -- Get extract date parameter values
2853: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_asg_id));
2854: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
2855: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
2856: -- Get Assignment Start and End Dates
2857: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));

Line 2857: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));

2853: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_asg_id));
2854: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
2855: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
2856: -- Get Assignment Start and End Dates
2857: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));
2858: l_asg_end_date := fnd_date.displaydate_to_date(get_prim_asg_end_date(p_asg_id));
2859:
2860: /* Bug- 12821023 if the vehicle is secondary and shared across assignments then do not
2861: report the vehicle, as it had been reported by its primary assignment.

Line 2858: l_asg_end_date := fnd_date.displaydate_to_date(get_prim_asg_end_date(p_asg_id));

2854: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
2855: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
2856: -- Get Assignment Start and End Dates
2857: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));
2858: l_asg_end_date := fnd_date.displaydate_to_date(get_prim_asg_end_date(p_asg_id));
2859:
2860: /* Bug- 12821023 if the vehicle is secondary and shared across assignments then do not
2861: report the vehicle, as it had been reported by its primary assignment.
2862: */

Line 2995: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_asg_id));

2991:
2992: BEGIN
2993: hr_utility.trace('Entering PROCESS_PRIM_VEH_04, p_asg_id='||p_asg_id);
2994: -- Get extract date parameter values
2995: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_asg_id));
2996: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
2997: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
2998: -- Get Assignment Start and End Dates
2999: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));

Line 2999: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));

2995: l_ben_start_date := fnd_date.displaydate_to_date(prim_ben_start_date(p_asg_id));
2996: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
2997: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
2998: -- Get Assignment Start and End Dates
2999: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));
3000: l_asg_end_date := fnd_date.displaydate_to_date(get_prim_asg_end_date(p_asg_id));
3001:
3002: /* Bug- 12821023 if the vehicle is secondary and shared across assignments then do not
3003: report the vehicle, as it had been reported by its primary assignment.

Line 3000: l_asg_end_date := fnd_date.displaydate_to_date(get_prim_asg_end_date(p_asg_id));

2996: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
2997: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
2998: -- Get Assignment Start and End Dates
2999: l_asg_start_date := fnd_date.displaydate_to_date(get_prim_asg_start_date(p_asg_id));
3000: l_asg_end_date := fnd_date.displaydate_to_date(get_prim_asg_end_date(p_asg_id));
3001:
3002: /* Bug- 12821023 if the vehicle is secondary and shared across assignments then do not
3003: report the vehicle, as it had been reported by its primary assignment.
3004: */