APPS.PAY_CA_EOY_RL2_AMEND_REG dependencies on PAY_ACTION_INFORMATION

Line 432: from pay_action_information

428: order by effective_end_date desc;
429:
430: CURSOR c_get_prov_amend_flag(cp_asg_act_id number) IS
431: select action_information2
432: from pay_action_information
433: where action_context_id = cp_asg_act_id
434: and action_information_category = 'CAEOY RL2 EMPLOYEE INFO2'
435: and action_context_type = 'AAP'
436: and jurisdiction_code = 'QC';