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 174: pay_action_information pai

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
178: and pai.action_information7 = fnd_date.date_to_canonical(p_effective_date) /*Bug 8402505*/