DBA Data[Home] [Help]

APPS.PAY_FR_DADS_PKG dependencies on PAY_ACTION_INFORMATION

Line 343: from pay_action_information pacinfo,

339: -- Cursor for getting establishment ids
340: -- from archived assignments
341: cursor S80 is
342: select distinct pacinfo.action_information7 estab_id
343: from pay_action_information pacinfo,
344: pay_assignment_actions pasac
345: where pacinfo.action_context_id = pasac.assignment_action_id
346: and pasac.payroll_action_id = p_payroll_action_id
347: and pacinfo.action_information_category = 'FR_DADS_FILE_DATA'