DBA Data[Home] [Help]

APPS.PAY_MX_YEAREND_REP dependencies on PAY_ACTION_INFORMATION

Line 48: pay_action_information pai,

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,
52: ff_contexts ffc,

Line 173: pay_action_information pai

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
177: and pai.action_context_id = paa.assignment_action_id