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,
3717: '
3718: end if;
3719: hr_utility.trace('2');
3720: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
3721: '
3722: '
3723: '
3724: '
3725: '
3725: '
3726: '
3727: nvl(van_entries.UNAVAILABLE_3,0) + nvl(van_entries.UNAVAILABLE_4,0)) || '
3728: '
3729: '
3730: '
3731: '
3732: '
3733: hr_utility.trace('3');
3741: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
3742: '
3743: end if;
3744: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
3745: '
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) ||
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: '
3770: '
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: '
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: || '
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: '
3777: '
3778: '