DBA Data[Home] [Help]

APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on STANDARD

Line 4105: nvl(ACTION_INFORMATION18,500) standard_charge,

4101: -- but has limittaion where the fields are repating
4102: -- and hence the format clause is used for STD_UNAVILA_VAL
4103: select decode(ACTION_INFORMATION6, null,'Y','Y','N','N','Y') exclusive_flag,
4104: ACTION_INFORMATION7 dreg,
4105: nvl(ACTION_INFORMATION18,500) standard_charge,
4106: nvl(ACTION_INFORMATION8,0) UNAVAILABLE_1,
4107: nvl(ACTION_INFORMATION9,0) UNAVAILABLE_2,
4108: nvl(ACTION_INFORMATION10,0) UNAVAILABLE_3,
4109: nvl(ACTION_INFORMATION11,0) UNAVAILABLE_4,

Line 4386: '' ||van_entries.standard_charge || ' ' ||

4382: '' ||'N' || ' ' ;
4383: end if;
4384: hr_utility.trace('2');
4385: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
4386: '' ||van_entries.standard_charge || ' ' ||
4387: '' ||van_entries.UNAVAILABLE_1 || ' ' ||
4388: '' ||van_entries.UNAVAILABLE_2 || ' ' ||
4389: '' ||van_entries.UNAVAILABLE_3 || ' ' ||
4390: '' ||van_entries.UNAVAILABLE_4 || ' ' ||

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

4390: '' ||van_entries.UNAVAILABLE_4 || ' ' ||
4391: '' ||(nvl(van_entries.UNAVAILABLE_1,0) + nvl(van_entries.UNAVAILABLE_2,0) +
4392: nvl(van_entries.UNAVAILABLE_3,0) + nvl(van_entries.UNAVAILABLE_4,0)) || '
' ||
4393: '' ||van_entries.UNAVAILABLE_VAL || ' ' ||
4394: '' || (nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0)) || ' ' ||
4395: '' ||van_entries.PVT_USE_PAYMENT || ' ' ||
4396: '' ||van_entries.CASH_EQUIVALENT || ' ' ||
4397: '' ||van_entries.CASH_EQUIVALENT || ' ' ;
4398: hr_utility.trace('3');

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

4406: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
4407: '' ||'N' || ' ' ;
4408: end if;
4409: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
4410: '' ||van_entries.standard_charge || ' ' ;
4411: hr_utility.trace('5');
4412: if nvl(van_entries.UNAVAILABLE_VAL,0) = 0
4413: then
4414: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||

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

4428: end if;
4429: hr_utility.trace('8');
4430: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
4431: '' ||
4432: to_char(to_number((nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0))),
4433: 'FM999,999,990.00') || '
' ||
4434: '' || van_entries.NUM_SHARE || ' ' ||
4435: '' ||
4436: ((nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0))/van_entries.NUM_SHARE)

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

4432: to_char(to_number((nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0))),
4433: 'FM999,999,990.00') || ' ' ||
4434: '' || van_entries.NUM_SHARE || ' ' ||
4435: '' ||
4436: ((nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0))/van_entries.NUM_SHARE)
4437: || '
' ||
4438: '' ||
4439: ((nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0))/van_entries.NUM_SHARE)
4440: || '
' ||

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

4435: '' ||
4436: ((nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0))/van_entries.NUM_SHARE)
4437: || '
' ||
4438: '' ||
4439: ((nvl(van_entries.standard_charge,0) - nvl(van_entries.UNAVAILABLE_VAL,0))/van_entries.NUM_SHARE)
4440: || '
' ||
4441: '' ||van_entries.PVT_USE_PAYMENT || ' ' ||
4442: '' ||van_entries.CASH_EQUIVALENT || ' ' ||
4443: '' ||van_entries.CASH_EQUIVALENT || ' ' ;