DBA Data[Home] [Help]

APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on STANDARD

Line 3448: nvl(ACTION_INFORMATION18,500) standard_charge,

3444: -- but has limittaion where the fields are repating
3445: -- and hence the format clause is used for STD_UNAVILA_VAL
3446: select decode(ACTION_INFORMATION6, null,'Y','Y','N','N','Y') exclusive_flag,
3447: ACTION_INFORMATION7 dreg,
3448: nvl(ACTION_INFORMATION18,500) standard_charge,
3449: nvl(ACTION_INFORMATION8,0) UNAVAILABLE_1,
3450: nvl(ACTION_INFORMATION9,0) UNAVAILABLE_2,
3451: nvl(ACTION_INFORMATION10,0) UNAVAILABLE_3,
3452: nvl(ACTION_INFORMATION11,0) UNAVAILABLE_4,

Line 3721: '' ||van_entries.standard_charge || ' ' ||

3717: '' ||'N' || ' ' ;
3718: end if;
3719: hr_utility.trace('2');
3720: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
3721: '' ||van_entries.standard_charge || ' ' ||
3722: '' ||van_entries.UNAVAILABLE_1 || ' ' ||
3723: '' ||van_entries.UNAVAILABLE_2 || ' ' ||
3724: '' ||van_entries.UNAVAILABLE_3 || ' ' ||
3725: '' ||van_entries.UNAVAILABLE_4 || ' ' ||

Line 3729: '' || (nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0)) || ' ' ||

3725: '' ||van_entries.UNAVAILABLE_4 || ' ' ||
3726: '' ||(nvl(van_entries.UNAVAILABLE_1,0) + nvl(van_entries.UNAVAILABLE_2,0) +
3727: nvl(van_entries.UNAVAILABLE_3,0) + nvl(van_entries.UNAVAILABLE_4,0)) || '
' ||
3728: '' ||van_entries.UNAVAILABLE_VAL || ' ' ||
3729: '' || (nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0)) || ' ' ||
3730: '' ||van_entries.PVT_USE_PAYMENT || ' ' ||
3731: '' ||van_entries.CASH_EQUIVALENT || ' ' ||
3732: '' ||van_entries.CASH_EQUIVALENT || ' ' ;
3733: hr_utility.trace('3');

Line 3745: '' ||van_entries.standard_charge || ' ' ;

3741: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
3742: '' ||'N' || ' ' ;
3743: end if;
3744: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
3745: '' ||van_entries.standard_charge || ' ' ;
3746: hr_utility.trace('5');
3747: if nvl(van_entries.UNAVAILABLE_VAL,0) = 0
3748: then
3749: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||

Line 3767: to_char(to_number((nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0))),

3763: end if;
3764: hr_utility.trace('8');
3765: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
3766: '' ||
3767: to_char(to_number((nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0))),
3768: 'FM999,999,990.00') || '
' ||
3769: '' || van_entries.NUM_SHARE || ' ' ||
3770: '' ||
3771: ((nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0))/van_entries.NUM_SHARE)

Line 3771: ((nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0))/van_entries.NUM_SHARE)

3767: to_char(to_number((nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0))),
3768: 'FM999,999,990.00') || ' ' ||
3769: '' || van_entries.NUM_SHARE || ' ' ||
3770: '' ||
3771: ((nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0))/van_entries.NUM_SHARE)
3772: || '
' ||
3773: '' ||
3774: ((nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0))/van_entries.NUM_SHARE)
3775: || '
' ||

Line 3774: ((nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0))/van_entries.NUM_SHARE)

3770: '' ||
3771: ((nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0))/van_entries.NUM_SHARE)
3772: || '
' ||
3773: '' ||
3774: ((nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0))/van_entries.NUM_SHARE)
3775: || '
' ||
3776: '' ||van_entries.PVT_USE_PAYMENT || ' ' ||
3777: '' ||van_entries.CASH_EQUIVALENT || ' ' ||
3778: '' ||van_entries.CASH_EQUIVALENT || ' ' ;