43: hr_utility.trace('ye_balance_name : '||ye_balance_name);
44:
45: select round(SUM(nvl(fnd_number.canonical_to_number(fai.value),0)))
46: into l_bal_amt
47: from pay_assignment_actions paa,
48: pay_action_information pai,
49: ff_archive_items fai,
50: ff_archive_item_contexts fic,
51: ff_user_entities fue,
169: decode(nvl(action_information9,'N'),'Y', round(nvl(to_number(action_information24),0)),0) ,
170: decode(nvl(action_information9,'N'),'Y', round(nvl(to_number(action_information25),0)),0) ,
171: decode(nvl(action_information9,'N'),'Y', round(nvl(to_number(action_information27),0)),0) ,
172: to_number(action_information8 )
173: from pay_assignment_actions paa,
174: pay_action_information pai
175: where paa.payroll_action_id = p_payroll_action_id
176: and paa.serial_number = p_person_id
177: --and pai.effective_date = p_effective_date