DBA Data[Home] [Help]

APPS.PAY_IN_24QC_ER_RETURNS dependencies on PAY_PAYROLL_ACTIONS

Line 239: , pay_payroll_actions ppa

235: , NVL(pai.action_information29,'N')
236: ,'TOTAL_BATCH_NO=P'
237: , DECODE(LENGTH(pai.action_information29), 1, 1, 2, 1, 5, 2, 8, 3, 11, 4, 14, 5, 17,6,1)
238: FROM pay_action_information pai
239: , pay_payroll_actions ppa
240: WHERE pai.action_information_category = 'IN_24QC_ORG'
241: AND pai.action_context_type = 'PA'
242: AND pai.action_information1 = g_gre_org_id
243: AND pai.action_information3 = g_assess_year||g_quarter