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 436: if fnd_date.canonical_to_date(l_present_val) <>

432: if l_present_val is null
433: then
434: l_dummy := per_formula_functions.set_text(p_variable_name, p_variable_value);
435: else
436: if fnd_date.canonical_to_date(l_present_val) <>
437: fnd_date.canonical_to_date(p_variable_value)
438: then
439: l_warnmsg := '1';
440: if fnd_date.canonical_to_date(l_present_val) <

Line 437: fnd_date.canonical_to_date(p_variable_value)

433: then
434: l_dummy := per_formula_functions.set_text(p_variable_name, p_variable_value);
435: else
436: if fnd_date.canonical_to_date(l_present_val) <>
437: fnd_date.canonical_to_date(p_variable_value)
438: then
439: l_warnmsg := '1';
440: if fnd_date.canonical_to_date(l_present_val) <
441: fnd_date.canonical_to_date(p_variable_value)

Line 440: if fnd_date.canonical_to_date(l_present_val) <

436: if fnd_date.canonical_to_date(l_present_val) <>
437: fnd_date.canonical_to_date(p_variable_value)
438: then
439: l_warnmsg := '1';
440: if fnd_date.canonical_to_date(l_present_val) <
441: fnd_date.canonical_to_date(p_variable_value)
442: then
443: l_dummy := per_formula_functions.set_text(p_variable_name, p_variable_value);
444: end if;

Line 441: fnd_date.canonical_to_date(p_variable_value)

437: fnd_date.canonical_to_date(p_variable_value)
438: then
439: l_warnmsg := '1';
440: if fnd_date.canonical_to_date(l_present_val) <
441: fnd_date.canonical_to_date(p_variable_value)
442: then
443: l_dummy := per_formula_functions.set_text(p_variable_name, p_variable_value);
444: end if;
445: end if;

Line 464: and fnd_date.canonical_to_date(p_effective_date) between

460: from hr_lookups hlu
461: where hlu.lookup_type = p_lookup_type
462: and hlu.lookup_code = p_lookup_code
463: and hlu.ENABLED_FLAG = 'Y'
464: and fnd_date.canonical_to_date(p_effective_date) between
465: nvl(hlu.START_DATE_ACTIVE,fnd_date.canonical_to_date(p_effective_date))
466: and nvl(hlu.END_DATE_ACTIVE,fnd_date.canonical_to_date(p_effective_date));
467: return l_description ;
468: exception

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

461: where hlu.lookup_type = p_lookup_type
462: and hlu.lookup_code = p_lookup_code
463: and hlu.ENABLED_FLAG = 'Y'
464: and fnd_date.canonical_to_date(p_effective_date) between
465: nvl(hlu.START_DATE_ACTIVE,fnd_date.canonical_to_date(p_effective_date))
466: and nvl(hlu.END_DATE_ACTIVE,fnd_date.canonical_to_date(p_effective_date));
467: return l_description ;
468: exception
469: when others then

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

462: and hlu.lookup_code = p_lookup_code
463: and hlu.ENABLED_FLAG = 'Y'
464: and fnd_date.canonical_to_date(p_effective_date) between
465: nvl(hlu.START_DATE_ACTIVE,fnd_date.canonical_to_date(p_effective_date))
466: and nvl(hlu.END_DATE_ACTIVE,fnd_date.canonical_to_date(p_effective_date));
467: return l_description ;
468: exception
469: when others then
470: l_description := null;

Line 2382: fnd_date.canonical_to_date(l_benefit_end_date));

2378: p_token_name => 'Run_Type',
2379: p_token_value => l_run_type_code);
2380: l_run_type_meaning := get_lookup_meaning('GB_P11D_RUN_TYPE',
2381: l_run_type_code,
2382: fnd_date.canonical_to_date(l_benefit_end_date));
2383: l_status_meaning := get_lookup_meaning('GB_P11D_LEGISLATIVE_RUN_STATUS',
2384: l_status_code,
2385: fnd_date.canonical_to_date(l_benefit_end_date));
2386: l_return_string := l_rep_run || ' ' || l_run_type_meaning || ' ' ||

Line 2385: fnd_date.canonical_to_date(l_benefit_end_date));

2381: l_run_type_code,
2382: fnd_date.canonical_to_date(l_benefit_end_date));
2383: l_status_meaning := get_lookup_meaning('GB_P11D_LEGISLATIVE_RUN_STATUS',
2384: l_status_code,
2385: fnd_date.canonical_to_date(l_benefit_end_date));
2386: l_return_string := l_rep_run || ' ' || l_run_type_meaning || ' ' ||
2387: l_status_meaning || ' ' ||
2388: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_benefit_start_date))||
2389: '/' ||

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

2384: l_status_code,
2385: fnd_date.canonical_to_date(l_benefit_end_date));
2386: l_return_string := l_rep_run || ' ' || l_run_type_meaning || ' ' ||
2387: l_status_meaning || ' ' ||
2388: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_benefit_start_date))||
2389: '/' ||
2390: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_benefit_end_date));
2391:
2392: if l_payroll_id is not null

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

2386: l_return_string := l_rep_run || ' ' || l_run_type_meaning || ' ' ||
2387: l_status_meaning || ' ' ||
2388: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_benefit_start_date))||
2389: '/' ||
2390: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_benefit_end_date));
2391:
2392: if l_payroll_id is not null
2393: then
2394: open csr_payroll(l_effective_date);

Line 2456: fnd_date.canonical_to_date(l_benefit_end_date));

2452: p_token_name => 'Status',
2453: p_token_value => l_status_code);
2454: l_status_meaning := get_lookup_meaning('GB_P11D_LEGISLATIVE_RUN_STATUS',
2455: l_status_code,
2456: fnd_date.canonical_to_date(l_benefit_end_date));
2457: return l_status_meaning;
2458: end;
2459:
2460: function fetch_leg_process_runtype(p_payroll_action_id in Number) return varchar2

Line 2476: fnd_date.canonical_to_date(l_benefit_end_date));

2472: p_token_name => 'Run_Type',
2473: p_token_value => l_run_type_code);
2474: l_run_type_meaning := get_lookup_meaning('GB_P11D_RUN_TYPE',
2475: l_run_type_code,
2476: fnd_date.canonical_to_date(l_benefit_end_date));
2477: return l_run_type_meaning;
2478: end;
2479:
2480: function fetch_leg_process_notes(p_payroll_action_id in Number) return varchar2

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

2640: cursor csr_living_acco (p_context_id NUMBER)
2641: is
2642: select pai_ben.ACTION_INFORMATION5 address,
2643: decode(months_between(
2644: fnd_date.canonical_to_date(pai_ben.action_information4)+1,
2645: fnd_date.canonical_to_date(pai_ben.action_information3)),12,'Y','N') full_year,
2646: to_char(to_number(nvl(pai_ben.action_information6,0)),'FM999,999,990.00') rent_employer,
2647: to_char(to_number(nvl(pai_ben.action_information7,0)),'FM999,999,990.00') annual_value,
2648: to_char(to_number(nvl(pai_ben.action_information18,0)),'FM999,999,990.00')Basic_Charge_Cost,

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

2641: is
2642: select pai_ben.ACTION_INFORMATION5 address,
2643: decode(months_between(
2644: fnd_date.canonical_to_date(pai_ben.action_information4)+1,
2645: fnd_date.canonical_to_date(pai_ben.action_information3)),12,'Y','N') full_year,
2646: to_char(to_number(nvl(pai_ben.action_information6,0)),'FM999,999,990.00') rent_employer,
2647: to_char(to_number(nvl(pai_ben.action_information7,0)),'FM999,999,990.00') annual_value,
2648: to_char(to_number(nvl(pai_ben.action_information18,0)),'FM999,999,990.00')Basic_Charge_Cost,
2649: to_char(to_number(nvl(pai_ben.action_information9,0)),'FM999,999,990.00') amg,

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

2673: decode(sign(pai_ben.action_information22),1,to_char(to_number(
2674: nvl(pai_ben.action_information19,0)+nvl(pai_ben.action_information17,0)),'FM999,999,990.00'),null) TOTAL ,
2675: decode(sign(pai_ben.action_information22),
2676: 1,decode(months_between(
2677: fnd_date.canonical_to_date(pai_ben.action_information4)+1,
2678: fnd_date.canonical_to_date(pai_ben.action_information3)),12,null,
2679: to_char(to_number(nvl(pai_ben.action_information15,0)))),null) NUMBER_OF_DAYS
2680: from pay_action_information pai_ben
2681: where pai_ben.action_information_category = 'LIVING ACCOMMODATION'

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

2674: nvl(pai_ben.action_information19,0)+nvl(pai_ben.action_information17,0)),'FM999,999,990.00'),null) TOTAL ,
2675: decode(sign(pai_ben.action_information22),
2676: 1,decode(months_between(
2677: fnd_date.canonical_to_date(pai_ben.action_information4)+1,
2678: fnd_date.canonical_to_date(pai_ben.action_information3)),12,null,
2679: to_char(to_number(nvl(pai_ben.action_information15,0)))),null) NUMBER_OF_DAYS
2680: from pay_action_information pai_ben
2681: where pai_ben.action_information_category = 'LIVING ACCOMMODATION'
2682: and pai_ben.action_context_id = p_context_id

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

3074: is
3075: select pai_emp.action_information3 ben_start,
3076: pai_emp.action_information4 ben_end,
3077: decode(months_between(
3078: fnd_date.canonical_to_date(pai_emp.action_information4)+1,
3079: fnd_date.canonical_to_date(pai_emp.action_information3)),12,'Y','N') FULL_YR_FLAG,
3080: -- pai_emp.ACTION_INFORMATION5,
3081: pai_emp.action_information6 make,
3082: pai_emp.action_information7 model,

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

3075: select pai_emp.action_information3 ben_start,
3076: pai_emp.action_information4 ben_end,
3077: decode(months_between(
3078: fnd_date.canonical_to_date(pai_emp.action_information4)+1,
3079: fnd_date.canonical_to_date(pai_emp.action_information3)),12,'Y','N') FULL_YR_FLAG,
3080: -- pai_emp.ACTION_INFORMATION5,
3081: pai_emp.action_information6 make,
3082: pai_emp.action_information7 model,
3083: pai_emp.action_information8 date_registered,

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

3137: select pai_emp.action_information3 ben_start,
3138: pai_emp.action_information4 ben_end,
3139: decode(
3140: months_between(
3141: fnd_date.canonical_to_date(pai_emp.action_information4)+1,
3142: fnd_date.canonical_to_date(pai_emp.action_information3)),12,'Y','N') FULL_YR_FLAG,
3143: --pai_emp.ACTION_INFORMATION5 co2,
3144: pai_emp.action_information6 make,
3145: pai_emp.action_information7 model,

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

3138: pai_emp.action_information4 ben_end,
3139: decode(
3140: months_between(
3141: fnd_date.canonical_to_date(pai_emp.action_information4)+1,
3142: fnd_date.canonical_to_date(pai_emp.action_information3)),12,'Y','N') FULL_YR_FLAG,
3143: --pai_emp.ACTION_INFORMATION5 co2,
3144: pai_emp.action_information6 make,
3145: pai_emp.action_information7 model,
3146: pai_emp.action_information8 date_registered,

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

3350: end if ;
3351: hr_utility.trace('A6');
3352: hr_utility.trace('date_registered ' ||car_rec.date_registered);
3353: -- calculating benefit charge section
3354: if fnd_date.canonical_to_date( car_rec.date_registered)
3355: >= to_date('01-01-1998','dd-mm-yyyy') and car_rec.CO2 is not null
3356: then
3357: hr_utility.trace('A');
3358: l_MOD_CO2 := floor(car_rec.CO2/5) * 5;

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

3392: l_ROUND_NORMAL_CO2 := floor(l_NORMAL_CO2);
3393: end if;
3394: hr_utility.trace('h');
3395: l_CAR_BENEFIT_1 := car_rec.ben_charge - car_rec.stand_disc - car_rec.additional_disc;
3396: elsif fnd_date.canonical_to_date( car_rec.date_registered)
3397: >= to_date('01-01-1998','dd-mm-yyyy') and car_rec.co2 is null
3398: then
3399: hr_utility.trace('i');
3400: if (car_rec.f_fuel = 'B' or car_rec.f_fuel = 'C' or

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

3429: else
3430: l_CAR_BENEFIT_2 := car_rec.ben_charge - car_rec.stand_disc;
3431: end if;
3432: l_full_DISC := null;
3433: elsif fnd_date.canonical_to_date( car_rec.date_registered)
3434: < to_date('01-01-1998','dd-mm-yyyy')
3435: then
3436: hr_utility.trace('K');
3437: -- hr_utility.trace('car_rec.benefit_charge '|| car_rec.benefit_charge);

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

3601: end if ;
3602: hr_utility.trace('A6');
3603: hr_utility.trace('date_registered ' ||car_rec.date_registered);
3604: -- calculating benefit charge section
3605: if fnd_date.canonical_to_date( car_rec.date_registered)
3606: >= to_date('01-01-1998','dd-mm-yyyy') and car_rec.CO2 is not null
3607: then
3608: hr_utility.trace('a');
3609: l_MOD_CO2 := floor(car_rec.CO2/5) * 5;

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

3622: end if;
3623: l_ROUND_NORMAL_CO2 := car_rec.ROUND_NORMAL_CO2;
3624: l_full_DISC := car_rec.FULL_DISC;
3625: l_CAR_BENEFIT_1 := car_rec.TOTAL_BENIFIT ;
3626: elsif fnd_date.canonical_to_date( car_rec.date_registered)
3627: >= to_date('01-01-1998','dd-mm-yyyy') and car_rec.CO2 is null
3628: then
3629: hr_utility.trace('e');
3630: -- below is the code snippet for P11D change 6.1.4.2

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

3639: end if;
3640: hr_utility.trace('f');
3641:
3642:
3643: elsif (fnd_date.canonical_to_date( car_rec.date_registered)< to_date('01-01-1998','dd-mm-yyyy'))
3644: then
3645: hr_utility.trace('g');
3646: -- hr_utility.trace('car_rec.benefit_charge '|| car_rec.benefit_charge);
3647: l_full_disc := null;

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

3816: hr_utility.trace('A6');
3817: hr_utility.trace('date_registered ' ||car_rec.date_registered);
3818: -- calculating benefit charge section
3819: if (to_number(l_rep_run)) > 2008 then --P11D 08/09
3820: if fnd_date.canonical_to_date( car_rec.date_registered)
3821: >= to_date('01-01-1998','dd-mm-yyyy') and car_rec.CO2 is not null
3822: and car_rec.CO2 > 120 -- P11D 08/09
3823: --hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_CO2_EMISSIONS',l_BEN_ED_DATE)
3824: then

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

3844: l_full_DISC := car_rec.FULL_DISC;
3845: l_CAR_BENEFIT_1 := car_rec.TOTAL_BENIFIT ;
3846: -- P11D 08/09
3847: /* bug 8277887 car_rec.CO2 is not null to nvl(car_rec.CO2,0) > 0 */
3848: elsif fnd_date.canonical_to_date(car_rec.date_registered)
3849: >= to_date('01-01-1998','dd-mm-yyyy') and nvl(car_rec.CO2,0) > 0
3850: and car_rec.CO2 <= 120 then -- P11D 08/09
3851: -- hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_CO2_EMISSIONS',l_BEN_ED_DATE)
3852: /* The below if condition will check for all the fuel types except for type 'D' Bug:10432169 */

Line 3854: car_rec.f_fuel = 'H' OR car_rec.f_fuel = 'P' OR ( car_rec.f_fuel = 'L' AND fnd_date.canonical_to_date(car_rec.date_registered)

3850: and car_rec.CO2 <= 120 then -- P11D 08/09
3851: -- hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_CO2_EMISSIONS',l_BEN_ED_DATE)
3852: /* The below if condition will check for all the fuel types except for type 'D' Bug:10432169 */
3853: if car_rec.f_fuel = 'B' OR car_rec.f_fuel = 'C' OR car_rec.f_fuel = 'G' OR
3854: car_rec.f_fuel = 'H' OR car_rec.f_fuel = 'P' OR ( car_rec.f_fuel = 'L' AND fnd_date.canonical_to_date(car_rec.date_registered)
3855: < to_date('01-01-2006','dd-mm-yyyy')) then
3856: if car_rec.CO2 <= 75 then
3857: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_PERCENTAGE_LOWER',car_rec.full_end_date) ;
3858: else

Line 3862: elsif (car_rec.f_fuel = 'L' AND fnd_date.canonical_to_date(car_rec.date_registered)

3858: else
3859: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_PERCENTAGE',car_rec.full_end_date) ;
3860: end if;
3861: /* The below if condition checks for the fuel type L and date registered should be greater than 1-1-2006 Bug:10432169 */
3862: elsif (car_rec.f_fuel = 'L' AND fnd_date.canonical_to_date(car_rec.date_registered)
3863: >= to_date('01-01-2006','dd-mm-yyyy')) OR car_rec.f_fuel = 'D' then
3864: if car_rec.CO2 <= 75 then
3865: l_CAR_BENEFIT_6 := hr_gb_process_p11d_entries_pkg.get_global_value('P11D_QUALEC_DIESEL_PERCENTAGE_LOWER',car_rec.full_end_date) ;
3866: else

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

3890: END IF;
3891:
3892: -- P11D 08/09
3893: /* bug 8277887 changed car_rec.co2 is null to nvl(car_rec.CO2,0) = 0 */
3894: elsif fnd_date.canonical_to_date( car_rec.date_registered)
3895: >= to_date('01-01-1998','dd-mm-yyyy') and nvl(car_rec.CO2,0) = 0
3896: then
3897: hr_utility.trace('e');
3898: --l_PERCENT_2 := car_rec.BENEFIT_PERCENT; --chnage this as below for 6.1.4.2 P11D change

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

3907: end if;
3908: hr_utility.trace('f');
3909:
3910:
3911: elsif (fnd_date.canonical_to_date( car_rec.date_registered)< to_date('01-01-1998','dd-mm-yyyy'))
3912: then
3913: hr_utility.trace('g');
3914: -- hr_utility.trace('car_rec.benefit_charge '|| car_rec.benefit_charge);
3915: l_full_disc := null;

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

3914: -- hr_utility.trace('car_rec.benefit_charge '|| car_rec.benefit_charge);
3915: l_full_disc := null;
3916: l_esize := car_rec.f_esize;
3917: open csr_engine_discount(to_number(l_esize),
3918: fnd_date.canonical_to_date(car_rec.ben_end));
3919: fetch csr_engine_discount into l_CAR_BENEFIT_3;
3920: close csr_engine_discount;
3921: end if;
3922:

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

3922:
3923:
3924: else
3925:
3926: if fnd_date.canonical_to_date( car_rec.date_registered)
3927: >= to_date('01-01-1998','dd-mm-yyyy') and car_rec.CO2 is not null
3928: then
3929: hr_utility.trace('a');
3930: l_MOD_CO2 := floor(car_rec.CO2/5) * 5;

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

3934: l_STD_DISC_1 := car_rec.STD_DISC;
3935: l_ROUND_NORMAL_CO2 := car_rec.ROUND_NORMAL_CO2;
3936: l_full_DISC := car_rec.FULL_DISC;
3937: l_CAR_BENEFIT_1 := car_rec.TOTAL_BENIFIT ;
3938: elsif fnd_date.canonical_to_date( car_rec.date_registered)
3939: >= to_date('01-01-1998','dd-mm-yyyy') and car_rec.CO2 is null
3940: then
3941: hr_utility.trace('e');
3942: --l_PERCENT_2 := car_rec.BENEFIT_PERCENT; -- below is the code snippet for P11D change 6.1.4.2

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

3951: end if;
3952: hr_utility.trace('f');
3953:
3954:
3955: elsif (fnd_date.canonical_to_date( car_rec.date_registered)< to_date('01-01-1998','dd-mm-yyyy'))
3956: then
3957: hr_utility.trace('g');
3958: -- hr_utility.trace('car_rec.benefit_charge '|| car_rec.benefit_charge);
3959: l_full_disc := null;

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

3958: -- hr_utility.trace('car_rec.benefit_charge '|| car_rec.benefit_charge);
3959: l_full_disc := null;
3960: l_esize := car_rec.f_esize;
3961: open csr_engine_discount(to_number(l_esize),
3962: fnd_date.canonical_to_date(car_rec.ben_end));
3963: fetch csr_engine_discount into l_CAR_BENEFIT_3;
3964: close csr_engine_discount;
3965: end if;
3966: end if;

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

4372: '' ||van_entries.exclusive_flag || ' ' ;
4373: hr_utility.trace('aa');
4374: if van_entries.exclusive_flag = 'Y'
4375: then -- we fill section 1
4376: if fnd_date.canonical_to_date(van_entries.dreg) > to_date('05-04-2000','dd-mm-yyyy')
4377: then
4378: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
4379: '' ||'Y' || ' ' ;
4380: else

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

4397: '' ||van_entries.CASH_EQUIVALENT || ' ' ;
4398: hr_utility.trace('3');
4399: else -- else of van_entries.exclusive_flag = 'Y'
4400: hr_utility.trace('4');
4401: if fnd_date.canonical_to_date(van_entries.dreg) > to_date('05-04-2000','dd-mm-yyyy')
4402: then
4403: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
4404: '' ||'Y' || ' ' ;
4405: else

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

4469: l_loop_count := l_loop_count+1;
4470: hr_utility.trace('Vans');
4471: l_after_flag := 'N';
4472: if to_number(l_rep_run) < 2007 then
4473: if fnd_date.canonical_to_date(vans_entries.date_registered) > to_date('05-04-2002','dd-mm-yyyy')
4474: then
4475: l_after_flag := 'Y';
4476: end if;
4477: else -- >= 2007

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

4474: then
4475: l_after_flag := 'Y';
4476: end if;
4477: else -- >= 2007
4478: if fnd_date.canonical_to_date(vans_entries.date_registered) > to_date('05-04-2003','dd-mm-yyyy')
4479: then
4480: l_after_flag := 'Y';
4481: end if;
4482: end if;

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

4481: end if;
4482: end if;
4483:
4484: /* check date from and date to */
4485: if fnd_date.canonical_to_date(vans_entries.van_from_b) = to_date(l_date_from,'DD-MM-YYYY') and
4486: fnd_date.canonical_to_date(vans_entries.van_to_b) = to_date(l_date_to,'DD-MM-YYYY')
4487: then
4488: vans_entries.van_from_b := null;
4489: vans_entries.van_to_b := null;

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

4482: end if;
4483:
4484: /* check date from and date to */
4485: if fnd_date.canonical_to_date(vans_entries.van_from_b) = to_date(l_date_from,'DD-MM-YYYY') and
4486: fnd_date.canonical_to_date(vans_entries.van_to_b) = to_date(l_date_to,'DD-MM-YYYY')
4487: then
4488: vans_entries.van_from_b := null;
4489: vans_entries.van_to_b := null;
4490: end if;

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

4588: --end of bug 7146755
4589: hr_utility.trace('Vans 2007');
4590: l_after_flag := 'N';
4591: /* if to_number(l_rep_run) < 2007 then
4592: if fnd_date.canonical_to_date(vans_entries.date_registered) > to_date('05-04-2002','dd-mm-yyyy')
4593: then
4594: l_after_flag := 'Y';
4595: end if;
4596: else -- >= 2007

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

4593: then
4594: l_after_flag := 'Y';
4595: end if;
4596: else -- >= 2007
4597: if fnd_date.canonical_to_date(vans_entries.date_registered) > to_date('05-04-2003','dd-mm-yyyy')
4598: then
4599: l_after_flag := 'Y';
4600: end if;
4601: end if; */

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

4601: end if; */
4602:
4603: /* check date from and date to */
4604:
4605: if fnd_date.canonical_to_date(vans_entries.van_from_b) = to_date(l_date_from,'DD-MM-YYYY') and
4606: fnd_date.canonical_to_date(vans_entries.van_to_b) = to_date(l_date_to,'DD-MM-YYYY')
4607: then
4608: vans_entries.van_from_b := null;
4609: vans_entries.van_to_b := null;

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

4602:
4603: /* check date from and date to */
4604:
4605: if fnd_date.canonical_to_date(vans_entries.van_from_b) = to_date(l_date_from,'DD-MM-YYYY') and
4606: fnd_date.canonical_to_date(vans_entries.van_to_b) = to_date(l_date_to,'DD-MM-YYYY')
4607: then
4608: vans_entries.van_from_b := null;
4609: vans_entries.van_to_b := null;
4610: end if;

Line 5464: fnd_date.canonical_to_date(ACTION_INFORMATION4))

5460: 'EXPENSES PAYMENTS','Expenses') SECTION_HEADING,
5461: decode(action_information_category,
5462: 'ASSETS TRANSFERRED',get_lookup_meaning(
5463: 'GB_ASSET_TYPE',ACTION_INFORMATION6,
5464: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5465: || ' ' || ACTION_INFORMATION5,
5466: 'PAYMENTS MADE FOR EMP',get_lookup_meaning(
5467: 'GB_PAYMENTS_MADE',ACTION_INFORMATION6,
5468: fnd_date.canonical_to_date(ACTION_INFORMATION4))

Line 5468: fnd_date.canonical_to_date(ACTION_INFORMATION4))

5464: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5465: || ' ' || ACTION_INFORMATION5,
5466: 'PAYMENTS MADE FOR EMP',get_lookup_meaning(
5467: 'GB_PAYMENTS_MADE',ACTION_INFORMATION6,
5468: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5469: || ' ' || ACTION_INFORMATION5,
5470: 'VOUCHERS OR CREDIT CARDS',ACTION_INFORMATION5,
5471: 'PVT MED TREATMENT OR INSURANCE',ACTION_INFORMATION10,
5472: 'SERVICES SUPPLIED',ACTION_INFORMATION10,

Line 5475: fnd_date.canonical_to_date(ACTION_INFORMATION4))

5471: 'PVT MED TREATMENT OR INSURANCE',ACTION_INFORMATION10,
5472: 'SERVICES SUPPLIED',ACTION_INFORMATION10,
5473: 'ASSETS AT EMP DISPOSAL',get_lookup_meaning(
5474: 'GB_ASSETS',ACTION_INFORMATION5,
5475: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5476: || ' ' || ACTION_INFORMATION6,
5477: 'P11D SHARES','Share Related Benefits',
5478: 'OTHER ITEMS',replace(get_lookup_meaning(
5479: 'GB_OTHER_ITEMS',ACTION_INFORMATION5,

Line 5480: fnd_date.canonical_to_date(ACTION_INFORMATION4))

5476: || ' ' || ACTION_INFORMATION6,
5477: 'P11D SHARES','Share Related Benefits',
5478: 'OTHER ITEMS',replace(get_lookup_meaning(
5479: 'GB_OTHER_ITEMS',ACTION_INFORMATION5,
5480: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5481: || ' ' || ACTION_INFORMATION6,'&','&'),
5482: 'OTHER ITEMS NON 1A',get_lookup_meaning(
5483: 'GB_OTHER_ITEMS_NON_1A',ACTION_INFORMATION5,
5484: fnd_date.canonical_to_date(ACTION_INFORMATION4))

Line 5484: fnd_date.canonical_to_date(ACTION_INFORMATION4))

5480: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5481: || ' ' || ACTION_INFORMATION6,'&','&'),
5482: 'OTHER ITEMS NON 1A',get_lookup_meaning(
5483: 'GB_OTHER_ITEMS_NON_1A',ACTION_INFORMATION5,
5484: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5485: || ' ' || ACTION_INFORMATION6,
5486: 'EXPENSES PAYMENTS',get_lookup_meaning(
5487: 'GB_EXPENSE_TYPE',ACTION_INFORMATION5,
5488: fnd_date.canonical_to_date(ACTION_INFORMATION4))

Line 5488: fnd_date.canonical_to_date(ACTION_INFORMATION4))

5484: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5485: || ' ' || ACTION_INFORMATION6,
5486: 'EXPENSES PAYMENTS',get_lookup_meaning(
5487: 'GB_EXPENSE_TYPE',ACTION_INFORMATION5,
5488: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5489: || ' ' || ACTION_INFORMATION9) LINE_DETAIL,
5490: decode(action_information_category,
5491: 'ASSETS TRANSFERRED',ACTION_INFORMATION7,
5492: 'PAYMENTS MADE FOR EMP',null,

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

5519: 'P11D SHARES',decode(ACTION_INFORMATION5,'Y','Yes'),
5520: 'OTHER ITEMS',ACTION_INFORMATION9,
5521: 'OTHER ITEMS NON 1A',ACTION_INFORMATION9,
5522: 'EXPENSES PAYMENTS',ACTION_INFORMATION8) LINE_COL3,
5523: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION3),'DD-MON-YYYY') LINE_START_DATE,
5524: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION4),'DD-MON-YYYY') LINE_END_DATE
5525: from pay_action_information
5526: where action_information_category in(
5527: 'ASSETS TRANSFERRED',

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

5520: 'OTHER ITEMS',ACTION_INFORMATION9,
5521: 'OTHER ITEMS NON 1A',ACTION_INFORMATION9,
5522: 'EXPENSES PAYMENTS',ACTION_INFORMATION8) LINE_COL3,
5523: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION3),'DD-MON-YYYY') LINE_START_DATE,
5524: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION4),'DD-MON-YYYY') LINE_END_DATE
5525: from pay_action_information
5526: where action_information_category in(
5527: 'ASSETS TRANSFERRED',
5528: 'PAYMENTS MADE FOR EMP',

Line 5604: fnd_date.canonical_to_date(ACTION_INFORMATION4))

5600: 'EXPENSES PAYMENTS','Expenses') SECTION_HEADING,
5601: decode(action_information_category,
5602: 'ASSETS TRANSFERRED',get_lookup_meaning(
5603: 'GB_ASSET_TYPE', ACTION_INFORMATION6,
5604: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5605: || ' ' || ACTION_INFORMATION5,
5606: 'PAYMENTS MADE FOR EMP',get_lookup_meaning(
5607: 'GB_PAYMENTS_MADE', ACTION_INFORMATION6,
5608: fnd_date.canonical_to_date(ACTION_INFORMATION4))

Line 5608: fnd_date.canonical_to_date(ACTION_INFORMATION4))

5604: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5605: || ' ' || ACTION_INFORMATION5,
5606: 'PAYMENTS MADE FOR EMP',get_lookup_meaning(
5607: 'GB_PAYMENTS_MADE', ACTION_INFORMATION6,
5608: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5609: || ' ' || ACTION_INFORMATION5,
5610: 'VOUCHERS OR CREDIT CARDS',ACTION_INFORMATION5,
5611: 'PVT MED TREATMENT OR INSURANCE',ACTION_INFORMATION10,
5612: 'SERVICES SUPPLIED',ACTION_INFORMATION10,

Line 5615: fnd_date.canonical_to_date(ACTION_INFORMATION4))

5611: 'PVT MED TREATMENT OR INSURANCE',ACTION_INFORMATION10,
5612: 'SERVICES SUPPLIED',ACTION_INFORMATION10,
5613: 'ASSETS AT EMP DISPOSAL',get_lookup_meaning(
5614: 'GB_ASSETS', ACTION_INFORMATION5,
5615: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5616: || ' ' || ACTION_INFORMATION6,
5617: 'OTHER ITEMS',replace(get_lookup_meaning(
5618: 'GB_OTHER_ITEMS',ACTION_INFORMATION5,
5619: fnd_date.canonical_to_date(ACTION_INFORMATION4))

Line 5619: fnd_date.canonical_to_date(ACTION_INFORMATION4))

5615: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5616: || ' ' || ACTION_INFORMATION6,
5617: 'OTHER ITEMS',replace(get_lookup_meaning(
5618: 'GB_OTHER_ITEMS',ACTION_INFORMATION5,
5619: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5620: || ' ' || ACTION_INFORMATION6,'&','&'),
5621: 'OTHER ITEMS NON 1A',get_lookup_meaning(
5622: 'GB_OTHER_ITEMS_NON_1A', ACTION_INFORMATION5,
5623: fnd_date.canonical_to_date(ACTION_INFORMATION4))

Line 5623: fnd_date.canonical_to_date(ACTION_INFORMATION4))

5619: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5620: || ' ' || ACTION_INFORMATION6,'&','&'),
5621: 'OTHER ITEMS NON 1A',get_lookup_meaning(
5622: 'GB_OTHER_ITEMS_NON_1A', ACTION_INFORMATION5,
5623: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5624: || ' ' || ACTION_INFORMATION6,
5625: 'EXPENSES PAYMENTS',get_lookup_meaning(
5626: 'GB_EXPENSE_TYPE',ACTION_INFORMATION5,
5627: fnd_date.canonical_to_date(ACTION_INFORMATION4))

Line 5627: fnd_date.canonical_to_date(ACTION_INFORMATION4))

5623: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5624: || ' ' || ACTION_INFORMATION6,
5625: 'EXPENSES PAYMENTS',get_lookup_meaning(
5626: 'GB_EXPENSE_TYPE',ACTION_INFORMATION5,
5627: fnd_date.canonical_to_date(ACTION_INFORMATION4))
5628: || ' ' || ACTION_INFORMATION9) LINE_DETAIL,
5629: decode(action_information_category,
5630: 'ASSETS TRANSFERRED',ACTION_INFORMATION7,
5631: 'PAYMENTS MADE FOR EMP',null,

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

5655: 'ASSETS AT EMP DISPOSAL',ACTION_INFORMATION9,
5656: 'OTHER ITEMS',ACTION_INFORMATION9,
5657: 'OTHER ITEMS NON 1A',ACTION_INFORMATION9,
5658: 'EXPENSES PAYMENTS',ACTION_INFORMATION8) LINE_COL3,
5659: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION3),'DD-MON-YYYY') LINE_START_DATE,
5660: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION4),'DD-MON-YYYY') LINE_END_DATE
5661: from pay_action_information
5662: where action_information_category in(
5663: 'ASSETS TRANSFERRED',

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

5656: 'OTHER ITEMS',ACTION_INFORMATION9,
5657: 'OTHER ITEMS NON 1A',ACTION_INFORMATION9,
5658: 'EXPENSES PAYMENTS',ACTION_INFORMATION8) LINE_COL3,
5659: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION3),'DD-MON-YYYY') LINE_START_DATE,
5660: to_char(fnd_date.canonical_to_date(ACTION_INFORMATION4),'DD-MON-YYYY') LINE_END_DATE
5661: from pay_action_information
5662: where action_information_category in(
5663: 'ASSETS TRANSFERRED',
5664: 'PAYMENTS MADE FOR EMP',