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.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on FND_DATE

Line 355: and fnd_date.canonical_to_date(p_benefit_end_date)

351: select global_value
352: from ff_globals_f
353: where legislation_code = 'GB'
354: and GLOBAL_NAME = p_global_name
355: and fnd_date.canonical_to_date(p_benefit_end_date)
356: between effective_start_date and effective_end_date;
357: begin
358: hr_utility.TRACE('p_benefit_end_date '|| p_benefit_end_date);
359: hr_utility.TRACE('p_global_name '|| p_global_name);

Line 428: if fnd_date.canonical_to_date(l_present_val) <>

424: if l_present_val is null
425: then
426: l_dummy := per_formula_functions.set_text(p_variable_name, p_variable_value);
427: else
428: if fnd_date.canonical_to_date(l_present_val) <>
429: fnd_date.canonical_to_date(p_variable_value)
430: then
431: l_warnmsg := '1';
432: if fnd_date.canonical_to_date(l_present_val) <

Line 429: fnd_date.canonical_to_date(p_variable_value)

425: then
426: l_dummy := per_formula_functions.set_text(p_variable_name, p_variable_value);
427: else
428: if fnd_date.canonical_to_date(l_present_val) <>
429: fnd_date.canonical_to_date(p_variable_value)
430: then
431: l_warnmsg := '1';
432: if fnd_date.canonical_to_date(l_present_val) <
433: fnd_date.canonical_to_date(p_variable_value)

Line 432: if fnd_date.canonical_to_date(l_present_val) <

428: if fnd_date.canonical_to_date(l_present_val) <>
429: fnd_date.canonical_to_date(p_variable_value)
430: then
431: l_warnmsg := '1';
432: if fnd_date.canonical_to_date(l_present_val) <
433: fnd_date.canonical_to_date(p_variable_value)
434: then
435: l_dummy := per_formula_functions.set_text(p_variable_name, p_variable_value);
436: end if;

Line 433: fnd_date.canonical_to_date(p_variable_value)

429: fnd_date.canonical_to_date(p_variable_value)
430: then
431: l_warnmsg := '1';
432: if fnd_date.canonical_to_date(l_present_val) <
433: fnd_date.canonical_to_date(p_variable_value)
434: then
435: l_dummy := per_formula_functions.set_text(p_variable_name, p_variable_value);
436: end if;
437: end if;

Line 456: and fnd_date.canonical_to_date(p_effective_date) between

452: from hr_lookups hlu
453: where hlu.lookup_type = p_lookup_type
454: and hlu.lookup_code = p_lookup_code
455: and hlu.ENABLED_FLAG = 'Y'
456: and fnd_date.canonical_to_date(p_effective_date) between
457: nvl(hlu.START_DATE_ACTIVE,fnd_date.canonical_to_date(p_effective_date))
458: and nvl(hlu.END_DATE_ACTIVE,fnd_date.canonical_to_date(p_effective_date));
459: return l_description ;
460: exception

Line 457: nvl(hlu.START_DATE_ACTIVE,fnd_date.canonical_to_date(p_effective_date))

453: where hlu.lookup_type = p_lookup_type
454: and hlu.lookup_code = p_lookup_code
455: and hlu.ENABLED_FLAG = 'Y'
456: and fnd_date.canonical_to_date(p_effective_date) between
457: nvl(hlu.START_DATE_ACTIVE,fnd_date.canonical_to_date(p_effective_date))
458: and nvl(hlu.END_DATE_ACTIVE,fnd_date.canonical_to_date(p_effective_date));
459: return l_description ;
460: exception
461: when others then

Line 458: and nvl(hlu.END_DATE_ACTIVE,fnd_date.canonical_to_date(p_effective_date));

454: and hlu.lookup_code = p_lookup_code
455: and hlu.ENABLED_FLAG = 'Y'
456: and fnd_date.canonical_to_date(p_effective_date) between
457: nvl(hlu.START_DATE_ACTIVE,fnd_date.canonical_to_date(p_effective_date))
458: and nvl(hlu.END_DATE_ACTIVE,fnd_date.canonical_to_date(p_effective_date));
459: return l_description ;
460: exception
461: when others then
462: l_description := null;

Line 1930: fnd_date.canonical_to_date(l_benefit_end_date));

1926: p_token_name => 'Run_Type',
1927: p_token_value => l_run_type_code);
1928: l_run_type_meaning := get_lookup_meaning('GB_P11D_RUN_TYPE',
1929: l_run_type_code,
1930: fnd_date.canonical_to_date(l_benefit_end_date));
1931: l_status_meaning := get_lookup_meaning('GB_P11D_LEGISLATIVE_RUN_STATUS',
1932: l_status_code,
1933: fnd_date.canonical_to_date(l_benefit_end_date));
1934: l_return_string := l_rep_run || ' ' || l_run_type_meaning || ' ' ||

Line 1933: fnd_date.canonical_to_date(l_benefit_end_date));

1929: l_run_type_code,
1930: fnd_date.canonical_to_date(l_benefit_end_date));
1931: l_status_meaning := get_lookup_meaning('GB_P11D_LEGISLATIVE_RUN_STATUS',
1932: l_status_code,
1933: fnd_date.canonical_to_date(l_benefit_end_date));
1934: l_return_string := l_rep_run || ' ' || l_run_type_meaning || ' ' ||
1935: l_status_meaning || ' ' ||
1936: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_benefit_start_date))||
1937: '/' ||

Line 1936: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_benefit_start_date))||

1932: l_status_code,
1933: fnd_date.canonical_to_date(l_benefit_end_date));
1934: l_return_string := l_rep_run || ' ' || l_run_type_meaning || ' ' ||
1935: l_status_meaning || ' ' ||
1936: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_benefit_start_date))||
1937: '/' ||
1938: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_benefit_end_date));
1939:
1940: if l_payroll_id is not null

Line 1938: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_benefit_end_date));

1934: l_return_string := l_rep_run || ' ' || l_run_type_meaning || ' ' ||
1935: l_status_meaning || ' ' ||
1936: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_benefit_start_date))||
1937: '/' ||
1938: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_benefit_end_date));
1939:
1940: if l_payroll_id is not null
1941: then
1942: open csr_payroll(l_effective_date);

Line 2004: fnd_date.canonical_to_date(l_benefit_end_date));

2000: p_token_name => 'Status',
2001: p_token_value => l_status_code);
2002: l_status_meaning := get_lookup_meaning('GB_P11D_LEGISLATIVE_RUN_STATUS',
2003: l_status_code,
2004: fnd_date.canonical_to_date(l_benefit_end_date));
2005: return l_status_meaning;
2006: end;
2007:
2008: function fetch_leg_process_runtype(p_payroll_action_id in Number) return varchar2

Line 2024: fnd_date.canonical_to_date(l_benefit_end_date));

2020: p_token_name => 'Run_Type',
2021: p_token_value => l_run_type_code);
2022: l_run_type_meaning := get_lookup_meaning('GB_P11D_RUN_TYPE',
2023: l_run_type_code,
2024: fnd_date.canonical_to_date(l_benefit_end_date));
2025: return l_run_type_meaning;
2026: end;
2027:
2028: function fetch_leg_process_notes(p_payroll_action_id in Number) return varchar2

Line 2170: fnd_date.canonical_to_date(pai_ben.action_information4)+1,

2166: cursor csr_living_acco (p_context_id NUMBER)
2167: is
2168: select pai_ben.ACTION_INFORMATION5 address,
2169: decode(months_between(
2170: fnd_date.canonical_to_date(pai_ben.action_information4)+1,
2171: fnd_date.canonical_to_date(pai_ben.action_information3)),12,'Y','N') full_year,
2172: to_char(to_number(nvl(pai_ben.action_information6,0)),'FM999,999,990.00') rent_employer,
2173: to_char(to_number(nvl(pai_ben.action_information7,0)),'FM999,999,990.00') annual_value,
2174: to_char(to_number(nvl(pai_ben.action_information18,0)),'FM999,999,990.00')Basic_Charge_Cost,

Line 2171: fnd_date.canonical_to_date(pai_ben.action_information3)),12,'Y','N') full_year,

2167: is
2168: select pai_ben.ACTION_INFORMATION5 address,
2169: decode(months_between(
2170: fnd_date.canonical_to_date(pai_ben.action_information4)+1,
2171: fnd_date.canonical_to_date(pai_ben.action_information3)),12,'Y','N') full_year,
2172: to_char(to_number(nvl(pai_ben.action_information6,0)),'FM999,999,990.00') rent_employer,
2173: to_char(to_number(nvl(pai_ben.action_information7,0)),'FM999,999,990.00') annual_value,
2174: to_char(to_number(nvl(pai_ben.action_information18,0)),'FM999,999,990.00')Basic_Charge_Cost,
2175: to_char(to_number(nvl(pai_ben.action_information9,0)),'FM999,999,990.00') amg,

Line 2203: fnd_date.canonical_to_date(pai_ben.action_information4)+1,

2199: decode(sign(pai_ben.action_information22),1,to_char(to_number(
2200: nvl(pai_ben.action_information19,0)+nvl(pai_ben.action_information17,0)),'FM999,999,990.00'),null) TOTAL ,
2201: decode(sign(pai_ben.action_information22),
2202: 1,decode(months_between(
2203: fnd_date.canonical_to_date(pai_ben.action_information4)+1,
2204: fnd_date.canonical_to_date(pai_ben.action_information3)),12,null,
2205: to_char(to_number(nvl(pai_ben.action_information15,0)))),null) NUMBER_OF_DAYS
2206: from pay_action_information pai_ben
2207: where pai_ben.action_information_category = 'LIVING ACCOMMODATION'

Line 2204: fnd_date.canonical_to_date(pai_ben.action_information3)),12,null,

2200: nvl(pai_ben.action_information19,0)+nvl(pai_ben.action_information17,0)),'FM999,999,990.00'),null) TOTAL ,
2201: decode(sign(pai_ben.action_information22),
2202: 1,decode(months_between(
2203: fnd_date.canonical_to_date(pai_ben.action_information4)+1,
2204: fnd_date.canonical_to_date(pai_ben.action_information3)),12,null,
2205: to_char(to_number(nvl(pai_ben.action_information15,0)))),null) NUMBER_OF_DAYS
2206: from pay_action_information pai_ben
2207: where pai_ben.action_information_category = 'LIVING ACCOMMODATION'
2208: and pai_ben.action_context_id = p_context_id

Line 2592: fnd_date.canonical_to_date(pai_emp.action_information4)+1,

2588: is
2589: select pai_emp.action_information3 ben_start,
2590: pai_emp.action_information4 ben_end,
2591: decode(months_between(
2592: fnd_date.canonical_to_date(pai_emp.action_information4)+1,
2593: fnd_date.canonical_to_date(pai_emp.action_information3)),12,'Y','N') FULL_YR_FLAG,
2594: -- pai_emp.ACTION_INFORMATION5,
2595: pai_emp.action_information6 make,
2596: pai_emp.action_information7 model,

Line 2593: fnd_date.canonical_to_date(pai_emp.action_information3)),12,'Y','N') FULL_YR_FLAG,

2589: select pai_emp.action_information3 ben_start,
2590: pai_emp.action_information4 ben_end,
2591: decode(months_between(
2592: fnd_date.canonical_to_date(pai_emp.action_information4)+1,
2593: fnd_date.canonical_to_date(pai_emp.action_information3)),12,'Y','N') FULL_YR_FLAG,
2594: -- pai_emp.ACTION_INFORMATION5,
2595: pai_emp.action_information6 make,
2596: pai_emp.action_information7 model,
2597: pai_emp.action_information8 date_registered,

Line 2655: fnd_date.canonical_to_date(pai_emp.action_information4)+1,

2651: select pai_emp.action_information3 ben_start,
2652: pai_emp.action_information4 ben_end,
2653: decode(
2654: months_between(
2655: fnd_date.canonical_to_date(pai_emp.action_information4)+1,
2656: fnd_date.canonical_to_date(pai_emp.action_information3)),12,'Y','N') FULL_YR_FLAG,
2657: --pai_emp.ACTION_INFORMATION5 co2,
2658: pai_emp.action_information6 make,
2659: pai_emp.action_information7 model,

Line 2656: fnd_date.canonical_to_date(pai_emp.action_information3)),12,'Y','N') FULL_YR_FLAG,

2652: pai_emp.action_information4 ben_end,
2653: decode(
2654: months_between(
2655: fnd_date.canonical_to_date(pai_emp.action_information4)+1,
2656: fnd_date.canonical_to_date(pai_emp.action_information3)),12,'Y','N') FULL_YR_FLAG,
2657: --pai_emp.ACTION_INFORMATION5 co2,
2658: pai_emp.action_information6 make,
2659: pai_emp.action_information7 model,
2660: pai_emp.action_information8 date_registered,

Line 2857: if fnd_date.canonical_to_date( car_rec.date_registered)

2853: end if ;
2854: hr_utility.trace('A6');
2855: hr_utility.trace('date_registered ' ||car_rec.date_registered);
2856: -- calculating benefit charge section
2857: if fnd_date.canonical_to_date( car_rec.date_registered)
2858: >= to_date('01-01-1998','dd-mm-yyyy') and car_rec.CO2 is not null
2859: then
2860: hr_utility.trace('A');
2861: l_MOD_CO2 := floor(car_rec.CO2/5) * 5;

Line 2895: elsif fnd_date.canonical_to_date( car_rec.date_registered)

2891: l_ROUND_NORMAL_CO2 := floor(l_NORMAL_CO2);
2892: end if;
2893: hr_utility.trace('h');
2894: l_CAR_BENEFIT_1 := car_rec.ben_charge - car_rec.stand_disc - car_rec.additional_disc;
2895: elsif fnd_date.canonical_to_date( car_rec.date_registered)
2896: >= to_date('01-01-1998','dd-mm-yyyy') and car_rec.co2 is null
2897: then
2898: hr_utility.trace('i');
2899: if (car_rec.f_fuel = 'B' or car_rec.f_fuel = 'C' or

Line 2927: elsif fnd_date.canonical_to_date( car_rec.date_registered)

2923: end if;
2924: hr_utility.trace('j');
2925: l_CAR_BENEFIT_2 := car_rec.ben_charge - car_rec.stand_disc ;
2926: l_full_DISC := null;
2927: elsif fnd_date.canonical_to_date( car_rec.date_registered)
2928: < to_date('01-01-1998','dd-mm-yyyy')
2929: then
2930: hr_utility.trace('K');
2931: -- hr_utility.trace('car_rec.benefit_charge '|| car_rec.benefit_charge);

Line 3099: if fnd_date.canonical_to_date( car_rec.date_registered)

3095: end if ;
3096: hr_utility.trace('A6');
3097: hr_utility.trace('date_registered ' ||car_rec.date_registered);
3098: -- calculating benefit charge section
3099: if fnd_date.canonical_to_date( car_rec.date_registered)
3100: >= to_date('01-01-1998','dd-mm-yyyy') and car_rec.CO2 is not null
3101: then
3102: hr_utility.trace('a');
3103: l_MOD_CO2 := floor(car_rec.CO2/5) * 5;

Line 3120: elsif fnd_date.canonical_to_date( car_rec.date_registered)

3116: end if;
3117: l_ROUND_NORMAL_CO2 := car_rec.ROUND_NORMAL_CO2;
3118: l_full_DISC := car_rec.FULL_DISC;
3119: l_CAR_BENEFIT_1 := car_rec.TOTAL_BENIFIT ;
3120: elsif fnd_date.canonical_to_date( car_rec.date_registered)
3121: >= to_date('01-01-1998','dd-mm-yyyy') and car_rec.CO2 is null
3122: then
3123: hr_utility.trace('e');
3124: l_PERCENT_2 := car_rec.BENEFIT_PERCENT;

Line 3128: elsif (fnd_date.canonical_to_date( car_rec.date_registered)< to_date('01-01-1998','dd-mm-yyyy'))

3124: l_PERCENT_2 := car_rec.BENEFIT_PERCENT;
3125: hr_utility.trace('f');
3126: l_STD_DISC_2 := car_rec.STD_DISC;
3127: l_CAR_BENEFIT_2 := car_rec.TOTAL_BENIFIT_2;
3128: elsif (fnd_date.canonical_to_date( car_rec.date_registered)< to_date('01-01-1998','dd-mm-yyyy'))
3129: then
3130: hr_utility.trace('g');
3131: -- hr_utility.trace('car_rec.benefit_charge '|| car_rec.benefit_charge);
3132: l_full_disc := null;

Line 3303: if fnd_date.canonical_to_date( car_rec.date_registered)

3299: end if ;
3300: hr_utility.trace('A6');
3301: hr_utility.trace('date_registered ' ||car_rec.date_registered);
3302: -- calculating benefit charge section
3303: if fnd_date.canonical_to_date( car_rec.date_registered)
3304: >= to_date('01-01-1998','dd-mm-yyyy') and car_rec.CO2 is not null
3305: then
3306: hr_utility.trace('a');
3307: l_MOD_CO2 := floor(car_rec.CO2/5) * 5;

Line 3315: elsif fnd_date.canonical_to_date( car_rec.date_registered)

3311: l_STD_DISC_1 := car_rec.STD_DISC;
3312: l_ROUND_NORMAL_CO2 := car_rec.ROUND_NORMAL_CO2;
3313: l_full_DISC := car_rec.FULL_DISC;
3314: l_CAR_BENEFIT_1 := car_rec.TOTAL_BENIFIT ;
3315: elsif fnd_date.canonical_to_date( car_rec.date_registered)
3316: >= to_date('01-01-1998','dd-mm-yyyy') and car_rec.CO2 is null
3317: then
3318: hr_utility.trace('e');
3319: l_PERCENT_2 := car_rec.BENEFIT_PERCENT;

Line 3323: elsif (fnd_date.canonical_to_date( car_rec.date_registered)< to_date('01-01-1998','dd-mm-yyyy'))

3319: l_PERCENT_2 := car_rec.BENEFIT_PERCENT;
3320: hr_utility.trace('f');
3321: l_STD_DISC_2 := car_rec.STD_DISC;
3322: l_CAR_BENEFIT_2 := car_rec.TOTAL_BENIFIT_2;
3323: elsif (fnd_date.canonical_to_date( car_rec.date_registered)< to_date('01-01-1998','dd-mm-yyyy'))
3324: then
3325: hr_utility.trace('g');
3326: -- hr_utility.trace('car_rec.benefit_charge '|| car_rec.benefit_charge);
3327: l_full_disc := null;

Line 3330: fnd_date.canonical_to_date(car_rec.ben_end));

3326: -- hr_utility.trace('car_rec.benefit_charge '|| car_rec.benefit_charge);
3327: l_full_disc := null;
3328: l_esize := car_rec.f_esize;
3329: open csr_engine_discount(to_number(l_esize),
3330: fnd_date.canonical_to_date(car_rec.ben_end));
3331: fetch csr_engine_discount into l_CAR_BENEFIT_3;
3332: close csr_engine_discount;
3333: end if;
3334: hr_utility.trace('h');

Line 3711: if fnd_date.canonical_to_date(van_entries.dreg) > to_date('05-04-2000','dd-mm-yyyy')

3707: '' ||van_entries.exclusive_flag || ' ' ;
3708: hr_utility.trace('aa');
3709: if van_entries.exclusive_flag = 'Y'
3710: then -- we fill section 1
3711: if fnd_date.canonical_to_date(van_entries.dreg) > to_date('05-04-2000','dd-mm-yyyy')
3712: then
3713: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
3714: '' ||'Y' || ' ' ;
3715: else

Line 3736: if fnd_date.canonical_to_date(van_entries.dreg) > to_date('05-04-2000','dd-mm-yyyy')

3732: '' ||van_entries.CASH_EQUIVALENT || ' ' ;
3733: hr_utility.trace('3');
3734: else -- else of van_entries.exclusive_flag = 'Y'
3735: hr_utility.trace('4');
3736: if fnd_date.canonical_to_date(van_entries.dreg) > to_date('05-04-2000','dd-mm-yyyy')
3737: then
3738: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
3739: '' ||'Y' || ' ' ;
3740: else

Line 3808: if fnd_date.canonical_to_date(vans_entries.date_registered) > to_date('05-04-2002','dd-mm-yyyy')

3804: l_loop_count := l_loop_count+1;
3805: hr_utility.trace('Vans');
3806: l_after_flag := 'N';
3807: if to_number(l_rep_run) < 2007 then
3808: if fnd_date.canonical_to_date(vans_entries.date_registered) > to_date('05-04-2002','dd-mm-yyyy')
3809: then
3810: l_after_flag := 'Y';
3811: end if;
3812: else -- >= 2007

Line 3813: if fnd_date.canonical_to_date(vans_entries.date_registered) > to_date('05-04-2003','dd-mm-yyyy')

3809: then
3810: l_after_flag := 'Y';
3811: end if;
3812: else -- >= 2007
3813: if fnd_date.canonical_to_date(vans_entries.date_registered) > to_date('05-04-2003','dd-mm-yyyy')
3814: then
3815: l_after_flag := 'Y';
3816: end if;
3817: end if;

Line 3820: if fnd_date.canonical_to_date(vans_entries.van_from_b) = to_date(l_date_from,'DD-MM-YYYY') and

3816: end if;
3817: end if;
3818:
3819: /* check date from and date to */
3820: if fnd_date.canonical_to_date(vans_entries.van_from_b) = to_date(l_date_from,'DD-MM-YYYY') and
3821: fnd_date.canonical_to_date(vans_entries.van_to_b) = to_date(l_date_to,'DD-MM-YYYY')
3822: then
3823: vans_entries.van_from_b := null;
3824: vans_entries.van_to_b := null;

Line 3821: fnd_date.canonical_to_date(vans_entries.van_to_b) = to_date(l_date_to,'DD-MM-YYYY')

3817: end if;
3818:
3819: /* check date from and date to */
3820: if fnd_date.canonical_to_date(vans_entries.van_from_b) = to_date(l_date_from,'DD-MM-YYYY') and
3821: fnd_date.canonical_to_date(vans_entries.van_to_b) = to_date(l_date_to,'DD-MM-YYYY')
3822: then
3823: vans_entries.van_from_b := null;
3824: vans_entries.van_to_b := null;
3825: end if;

Line 3927: if fnd_date.canonical_to_date(vans_entries.date_registered) > to_date('05-04-2002','dd-mm-yyyy')

3923: --end of bug 7146755
3924: hr_utility.trace('Vans 2007');
3925: l_after_flag := 'N';
3926: /* if to_number(l_rep_run) < 2007 then
3927: if fnd_date.canonical_to_date(vans_entries.date_registered) > to_date('05-04-2002','dd-mm-yyyy')
3928: then
3929: l_after_flag := 'Y';
3930: end if;
3931: else -- >= 2007

Line 3932: if fnd_date.canonical_to_date(vans_entries.date_registered) > to_date('05-04-2003','dd-mm-yyyy')

3928: then
3929: l_after_flag := 'Y';
3930: end if;
3931: else -- >= 2007
3932: if fnd_date.canonical_to_date(vans_entries.date_registered) > to_date('05-04-2003','dd-mm-yyyy')
3933: then
3934: l_after_flag := 'Y';
3935: end if;
3936: end if; */

Line 3940: if fnd_date.canonical_to_date(vans_entries.van_from_b) = to_date(l_date_from,'DD-MM-YYYY') and

3936: end if; */
3937:
3938: /* check date from and date to */
3939:
3940: if fnd_date.canonical_to_date(vans_entries.van_from_b) = to_date(l_date_from,'DD-MM-YYYY') and
3941: fnd_date.canonical_to_date(vans_entries.van_to_b) = to_date(l_date_to,'DD-MM-YYYY')
3942: then
3943: vans_entries.van_from_b := null;
3944: vans_entries.van_to_b := null;

Line 3941: fnd_date.canonical_to_date(vans_entries.van_to_b) = to_date(l_date_to,'DD-MM-YYYY')

3937:
3938: /* check date from and date to */
3939:
3940: if fnd_date.canonical_to_date(vans_entries.van_from_b) = to_date(l_date_from,'DD-MM-YYYY') and
3941: fnd_date.canonical_to_date(vans_entries.van_to_b) = to_date(l_date_to,'DD-MM-YYYY')
3942: then
3943: vans_entries.van_from_b := null;
3944: vans_entries.van_to_b := null;
3945: end if;

Line 4683: fnd_date.canonical_to_date(ACTION_INFORMATION4))

4679: 'EXPENSES PAYMENTS','Expenses') SECTION_HEADING,
4680: decode(action_information_category,
4681: 'ASSETS TRANSFERRED',get_lookup_meaning(
4682: 'GB_ASSET_TYPE',ACTION_INFORMATION6,
4683: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4684: || ' ' || ACTION_INFORMATION5,
4685: 'PAYMENTS MADE FOR EMP',get_lookup_meaning(
4686: 'GB_PAYMENTS_MADE',ACTION_INFORMATION6,
4687: fnd_date.canonical_to_date(ACTION_INFORMATION4))

Line 4687: fnd_date.canonical_to_date(ACTION_INFORMATION4))

4683: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4684: || ' ' || ACTION_INFORMATION5,
4685: 'PAYMENTS MADE FOR EMP',get_lookup_meaning(
4686: 'GB_PAYMENTS_MADE',ACTION_INFORMATION6,
4687: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4688: || ' ' || ACTION_INFORMATION5,
4689: 'VOUCHERS OR CREDIT CARDS',ACTION_INFORMATION5,
4690: 'PVT MED TREATMENT OR INSURANCE',ACTION_INFORMATION10,
4691: 'SERVICES SUPPLIED',ACTION_INFORMATION10,

Line 4694: fnd_date.canonical_to_date(ACTION_INFORMATION4))

4690: 'PVT MED TREATMENT OR INSURANCE',ACTION_INFORMATION10,
4691: 'SERVICES SUPPLIED',ACTION_INFORMATION10,
4692: 'ASSETS AT EMP DISPOSAL',get_lookup_meaning(
4693: 'GB_ASSETS',ACTION_INFORMATION5,
4694: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4695: || ' ' || ACTION_INFORMATION6,
4696: 'P11D SHARES','Share Related Benefits',
4697: 'OTHER ITEMS',replace(get_lookup_meaning(
4698: 'GB_OTHER_ITEMS',ACTION_INFORMATION5,

Line 4699: fnd_date.canonical_to_date(ACTION_INFORMATION4))

4695: || ' ' || ACTION_INFORMATION6,
4696: 'P11D SHARES','Share Related Benefits',
4697: 'OTHER ITEMS',replace(get_lookup_meaning(
4698: 'GB_OTHER_ITEMS',ACTION_INFORMATION5,
4699: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4700: || ' ' || ACTION_INFORMATION6,'&','&'),
4701: 'OTHER ITEMS NON 1A',get_lookup_meaning(
4702: 'GB_OTHER_ITEMS_NON_1A',ACTION_INFORMATION5,
4703: fnd_date.canonical_to_date(ACTION_INFORMATION4))

Line 4703: fnd_date.canonical_to_date(ACTION_INFORMATION4))

4699: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4700: || ' ' || ACTION_INFORMATION6,'&','&'),
4701: 'OTHER ITEMS NON 1A',get_lookup_meaning(
4702: 'GB_OTHER_ITEMS_NON_1A',ACTION_INFORMATION5,
4703: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4704: || ' ' || ACTION_INFORMATION6,
4705: 'EXPENSES PAYMENTS',get_lookup_meaning(
4706: 'GB_EXPENSE_TYPE',ACTION_INFORMATION5,
4707: fnd_date.canonical_to_date(ACTION_INFORMATION4))

Line 4707: fnd_date.canonical_to_date(ACTION_INFORMATION4))

4703: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4704: || ' ' || ACTION_INFORMATION6,
4705: 'EXPENSES PAYMENTS',get_lookup_meaning(
4706: 'GB_EXPENSE_TYPE',ACTION_INFORMATION5,
4707: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4708: || ' ' || ACTION_INFORMATION9) LINE_DETAIL,
4709: decode(action_information_category,
4710: 'ASSETS TRANSFERRED',ACTION_INFORMATION7,
4711: 'PAYMENTS MADE FOR EMP',null,

Line 4742: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION3),'DD-MON-YYYY') LINE_START_DATE,

4738: 'P11D SHARES',decode(ACTION_INFORMATION5,'Y','Yes'),
4739: 'OTHER ITEMS',ACTION_INFORMATION9,
4740: 'OTHER ITEMS NON 1A',ACTION_INFORMATION9,
4741: 'EXPENSES PAYMENTS',ACTION_INFORMATION8) LINE_COL3,
4742: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION3),'DD-MON-YYYY') LINE_START_DATE,
4743: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION4),'DD-MON-YYYY') LINE_END_DATE
4744: from pay_action_information
4745: where action_information_category in(
4746: 'ASSETS TRANSFERRED',

Line 4743: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION4),'DD-MON-YYYY') LINE_END_DATE

4739: 'OTHER ITEMS',ACTION_INFORMATION9,
4740: 'OTHER ITEMS NON 1A',ACTION_INFORMATION9,
4741: 'EXPENSES PAYMENTS',ACTION_INFORMATION8) LINE_COL3,
4742: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION3),'DD-MON-YYYY') LINE_START_DATE,
4743: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION4),'DD-MON-YYYY') LINE_END_DATE
4744: from pay_action_information
4745: where action_information_category in(
4746: 'ASSETS TRANSFERRED',
4747: 'PAYMENTS MADE FOR EMP',

Line 4823: fnd_date.canonical_to_date(ACTION_INFORMATION4))

4819: 'EXPENSES PAYMENTS','Expenses') SECTION_HEADING,
4820: decode(action_information_category,
4821: 'ASSETS TRANSFERRED',get_lookup_meaning(
4822: 'GB_ASSET_TYPE', ACTION_INFORMATION6,
4823: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4824: || ' ' || ACTION_INFORMATION5,
4825: 'PAYMENTS MADE FOR EMP',get_lookup_meaning(
4826: 'GB_PAYMENTS_MADE', ACTION_INFORMATION6,
4827: fnd_date.canonical_to_date(ACTION_INFORMATION4))

Line 4827: fnd_date.canonical_to_date(ACTION_INFORMATION4))

4823: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4824: || ' ' || ACTION_INFORMATION5,
4825: 'PAYMENTS MADE FOR EMP',get_lookup_meaning(
4826: 'GB_PAYMENTS_MADE', ACTION_INFORMATION6,
4827: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4828: || ' ' || ACTION_INFORMATION5,
4829: 'VOUCHERS OR CREDIT CARDS',ACTION_INFORMATION5,
4830: 'PVT MED TREATMENT OR INSURANCE',ACTION_INFORMATION10,
4831: 'SERVICES SUPPLIED',ACTION_INFORMATION10,

Line 4834: fnd_date.canonical_to_date(ACTION_INFORMATION4))

4830: 'PVT MED TREATMENT OR INSURANCE',ACTION_INFORMATION10,
4831: 'SERVICES SUPPLIED',ACTION_INFORMATION10,
4832: 'ASSETS AT EMP DISPOSAL',get_lookup_meaning(
4833: 'GB_ASSETS', ACTION_INFORMATION5,
4834: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4835: || ' ' || ACTION_INFORMATION6,
4836: 'OTHER ITEMS',replace(get_lookup_meaning(
4837: 'GB_OTHER_ITEMS',ACTION_INFORMATION5,
4838: fnd_date.canonical_to_date(ACTION_INFORMATION4))

Line 4838: fnd_date.canonical_to_date(ACTION_INFORMATION4))

4834: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4835: || ' ' || ACTION_INFORMATION6,
4836: 'OTHER ITEMS',replace(get_lookup_meaning(
4837: 'GB_OTHER_ITEMS',ACTION_INFORMATION5,
4838: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4839: || ' ' || ACTION_INFORMATION6,'&','&'),
4840: 'OTHER ITEMS NON 1A',get_lookup_meaning(
4841: 'GB_OTHER_ITEMS_NON_1A', ACTION_INFORMATION5,
4842: fnd_date.canonical_to_date(ACTION_INFORMATION4))

Line 4842: fnd_date.canonical_to_date(ACTION_INFORMATION4))

4838: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4839: || ' ' || ACTION_INFORMATION6,'&','&'),
4840: 'OTHER ITEMS NON 1A',get_lookup_meaning(
4841: 'GB_OTHER_ITEMS_NON_1A', ACTION_INFORMATION5,
4842: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4843: || ' ' || ACTION_INFORMATION6,
4844: 'EXPENSES PAYMENTS',get_lookup_meaning(
4845: 'GB_EXPENSE_TYPE',ACTION_INFORMATION5,
4846: fnd_date.canonical_to_date(ACTION_INFORMATION4))

Line 4846: fnd_date.canonical_to_date(ACTION_INFORMATION4))

4842: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4843: || ' ' || ACTION_INFORMATION6,
4844: 'EXPENSES PAYMENTS',get_lookup_meaning(
4845: 'GB_EXPENSE_TYPE',ACTION_INFORMATION5,
4846: fnd_date.canonical_to_date(ACTION_INFORMATION4))
4847: || ' ' || ACTION_INFORMATION9) LINE_DETAIL,
4848: decode(action_information_category,
4849: 'ASSETS TRANSFERRED',ACTION_INFORMATION7,
4850: 'PAYMENTS MADE FOR EMP',null,

Line 4878: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION3),'DD-MON-YYYY') LINE_START_DATE,

4874: 'ASSETS AT EMP DISPOSAL',ACTION_INFORMATION9,
4875: 'OTHER ITEMS',ACTION_INFORMATION9,
4876: 'OTHER ITEMS NON 1A',ACTION_INFORMATION9,
4877: 'EXPENSES PAYMENTS',ACTION_INFORMATION8) LINE_COL3,
4878: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION3),'DD-MON-YYYY') LINE_START_DATE,
4879: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION4),'DD-MON-YYYY') LINE_END_DATE
4880: from pay_action_information
4881: where action_information_category in(
4882: 'ASSETS TRANSFERRED',

Line 4879: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION4),'DD-MON-YYYY') LINE_END_DATE

4875: 'OTHER ITEMS',ACTION_INFORMATION9,
4876: 'OTHER ITEMS NON 1A',ACTION_INFORMATION9,
4877: 'EXPENSES PAYMENTS',ACTION_INFORMATION8) LINE_COL3,
4878: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION3),'DD-MON-YYYY') LINE_START_DATE,
4879: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION4),'DD-MON-YYYY') LINE_END_DATE
4880: from pay_action_information
4881: where action_information_category in(
4882: 'ASSETS TRANSFERRED',
4883: 'PAYMENTS MADE FOR EMP',