DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ER_RETURNS dependencies on PAY_PAYROLL_ACTIONS

Line 243: , pay_payroll_actions ppa

239: , pai.action_context_id
240: , 'SUBMIT_DATE=P'
241: , TO_CHAR (SYSDATE,'DDMMYYYY')
242: FROM pay_action_information pai
243: , pay_payroll_actions ppa
244: WHERE pai.action_information_category = 'IN_24Q_ORG'
245: AND pai.action_context_type = 'PA'
246: AND pai.action_information1 = g_gre_org_id
247: AND pai.action_information3 =g_assess_year||g_quarter