DBA Data[Home] [Help]

APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 217: ,pay_payroll_actions ppa

213: UNION
214: SELECT DISTINCT action_information2 start_date
215: ,action_information3 end_date
216: FROM pay_action_information pai
217: ,pay_payroll_actions ppa
218: WHERE pai.action_context_type = 'PA'
219: AND pai.action_information_category = p_category
220: AND pai.action_context_id = ppa.payroll_action_id
221: AND ppa.payroll_action_id = p_action_context_id