DBA Data[Home] [Help]

APPS.PAY_MX_YEAREND_REP dependencies on PAY_ASSIGNMENT_ACTIONS

Line 47: from pay_assignment_actions paa,

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,

Line 172: from pay_assignment_actions paa,

168: decode(nvl(action_information9,'N'),'Y', round(nvl(to_number(action_information24),0)),0) ,
169: decode(nvl(action_information9,'N'),'Y', round(nvl(to_number(action_information25),0)),0) ,
170: decode(nvl(action_information9,'N'),'Y', round(nvl(to_number(action_information27),0)),0) ,
171: to_number(action_information8 )
172: from pay_assignment_actions paa,
173: pay_action_information pai
174: where paa.payroll_action_id = p_payroll_action_id
175: and paa.serial_number = p_person_id
176: and pai.effective_date = p_effective_date