DBA Data[Home] [Help]

APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on PAY_GB_P11D_MAGTAPE

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

955: substr(pai_emp.action_information8,1,4) f_dreg,
956: to_char(to_number(pai_emp.action_information9),'FM999,999,990.00') f_lprice,
957: to_char(to_number(pai_emp.action_information10),'FM999,999,990.00') f_cc,
958: to_char(to_number(pai_emp.action_information11),'FM999,999,990.00') f_fcc,
959: decode( pai_emp.action_information12,'0',null,PAY_GB_P11D_MAGTAPE.get_description(
960: pai_emp.action_information12,'GB_FUEL_TYPE',pai_emp.action_information4)) f_fuel,
961: pai_emp.action_information13 f_efig,
962: decode(pai_emp.action_information13,null,'Y', 'N') f_nfig,
963: to_char(to_number(pai_emp.action_information15),'FM999,999,990.00') f_oprice,

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

1007: if l_f_count > 0
1008: then
1009: hr_utility.trace('l_payroll_action_id ' || g_payroll_action_id);
1010: hr_utility.trace('l_person_id ' || g_person_id);
1011: l_tax_year := pay_gb_p11d_magtape.get_parameters(g_payroll_action_id,'Rep_Run');
1012: l_tax_year_end := l_tax_year || '0405';
1013: l_tax_year_start := to_char(to_number(l_tax_year) - 1) || '0406';
1014: for car_benefits in csr_car_benefits(g_payroll_action_id,
1015: g_person_id,

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

2607: substr(pai_emp.action_information4,1,4) f_end,
2608: to_char(to_number(nvl(pai_emp.action_information9,0)),'FM999,999,990.00') f_lprice,
2609: to_char(to_number(nvl(pai_emp.action_information10,0)),'FM999,999,990.00') f_cc,
2610: to_char(to_number(nvl(pai_emp.action_information11,0)),'FM999,999,990.00') f_fcc,
2611: decode( pai_emp.action_information12,'0',null,PAY_GB_P11D_MAGTAPE.get_description(
2612: pai_emp.action_information12,'GB_FUEL_TYPE',pai_emp.action_information4)) f_fuel,
2613: -- DECODE(pai_emp.action_information13, NULL, 'On', 'Off') f_nfig,
2614: to_char(to_number(nvl(pai_emp.action_information16,0)),'FM999,999,990.00') f_oprice,
2615: to_char(to_number(nvl(pai_emp.action_information9,0) +nvl(pai_emp.action_information16,0)),

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

2670: substr(pai_emp.action_information4,1,4) f_end,
2671: to_char(to_number(nvl(pai_emp.action_information9,0)),'FM999,999,990.00') f_lprice,
2672: to_char(to_number(nvl(pai_emp.action_information10,0)),'FM999,999,990.00') f_cc,
2673: to_char(to_number(nvl(pai_emp.action_information11,0)),'FM999,999,990.00') f_fcc,
2674: decode(pai_emp.action_information12,'0',null,PAY_GB_P11D_MAGTAPE.get_description(
2675: pai_emp.action_information12,'GB_FUEL_TYPE',pai_emp.action_information4)) f_fuel,
2676: to_char(to_number(nvl(pai_emp.action_information15,0)),'FM999,999,990.00') f_oprice,
2677: to_char(to_number(nvl(pai_emp.action_information9,0) +
2678: nvl(pai_emp.action_information15,0)),'FM999,999,990.00') TOTAL_INIT_PRICE,