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,
4382: '
4383: end if;
4384: hr_utility.trace('2');
4385: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
4386: '
4387: '
4388: '
4389: '
4390: '
4390: '
4391: '
4392: nvl(van_entries.UNAVAILABLE_3,0) + nvl(van_entries.UNAVAILABLE_4,0)) || '
4393: '
4394: '
4395: '
4396: '
4397: '
4398: hr_utility.trace('3');
4406: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
4407: '
4408: end if;
4409: l_xfdf_str_tab(l_loop_count) := l_xfdf_str_tab(l_loop_count) ||
4410: '
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) ||
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: '
4435: '
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: '
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: || '
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: '
4442: '
4443: '