DBA Data[Home] [Help]

APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on PAY_GB_P11D_MAGTAPE

Line 967: decode( pai_emp.action_information12,'0',null,PAY_GB_P11D_MAGTAPE.get_description(

963: substr(pai_emp.action_information8,1,4) f_dreg,
964: to_char(to_number(pai_emp.action_information9),'FM999,999,990.00') f_lprice,
965: to_char(to_number(pai_emp.action_information10),'FM999,999,990.00') f_cc,
966: to_char(to_number(pai_emp.action_information11),'FM999,999,990.00') f_fcc,
967: decode( pai_emp.action_information12,'0',null,PAY_GB_P11D_MAGTAPE.get_description(
968: pai_emp.action_information12,'GB_FUEL_TYPE',pai_emp.action_information4)) f_fuel,
969: pai_emp.action_information13 f_efig,
970: /* bug 8277887 checking the flag if co2 emisiion is either zero or null */
971: decode(NVL(pai_emp.action_information13,'0'),'0','Y', 'N') f_nfig,

Line 1020: l_tax_year := pay_gb_p11d_magtape.get_parameters(g_payroll_action_id,'Rep_Run');

1016: if l_f_count > 0
1017: then
1018: hr_utility.trace('l_payroll_action_id ' || g_payroll_action_id);
1019: hr_utility.trace('l_person_id ' || g_person_id);
1020: l_tax_year := pay_gb_p11d_magtape.get_parameters(g_payroll_action_id,'Rep_Run');
1021: l_tax_year_end := l_tax_year || '0405';
1022: l_tax_year_start := to_char(to_number(l_tax_year) - 1) || '0406';
1023: for car_benefits in csr_car_benefits(g_payroll_action_id,
1024: g_person_id,

Line 3097: decode( pai_emp.action_information12,'0',null,PAY_GB_P11D_MAGTAPE.get_description(

3093: substr(pai_emp.action_information4,1,4) f_end,
3094: to_char(to_number(nvl(pai_emp.action_information9,0)),'FM999,999,990.00') f_lprice,
3095: to_char(to_number(nvl(pai_emp.action_information10,0)),'FM999,999,990.00') f_cc,
3096: to_char(to_number(nvl(pai_emp.action_information11,0)),'FM999,999,990.00') f_fcc,
3097: decode( pai_emp.action_information12,'0',null,PAY_GB_P11D_MAGTAPE.get_description(
3098: pai_emp.action_information12,'GB_FUEL_TYPE',pai_emp.action_information4)) f_fuel,
3099: -- DECODE(pai_emp.action_information13, NULL, 'On', 'Off') f_nfig,
3100: to_char(to_number(nvl(pai_emp.action_information16,0)),'FM999,999,990.00') f_oprice,
3101: to_char(to_number(nvl(pai_emp.action_information9,0) +nvl(pai_emp.action_information16,0)),

Line 3160: decode(pai_emp.action_information12,'0',null,PAY_GB_P11D_MAGTAPE.get_description(

3156: substr(pai_emp.action_information4,1,4) f_end,
3157: to_char(to_number(nvl(pai_emp.action_information9,0)),'FM999,999,990.00') f_lprice,
3158: to_char(to_number(nvl(pai_emp.action_information10,0)),'FM999,999,990.00') f_cc,
3159: to_char(to_number(nvl(pai_emp.action_information11,0)),'FM999,999,990.00') f_fcc,
3160: decode(pai_emp.action_information12,'0',null,PAY_GB_P11D_MAGTAPE.get_description(
3161: pai_emp.action_information12,'GB_FUEL_TYPE',pai_emp.action_information4)) f_fuel,
3162: to_char(to_number(nvl(pai_emp.action_information15,0)),'FM999,999,990.00') f_oprice,
3163: to_char(to_number(nvl(pai_emp.action_information9,0) +
3164: nvl(pai_emp.action_information15,0)),'FM999,999,990.00') TOTAL_INIT_PRICE,