[Home] [Help]
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