53: CURSOR asg_roe_info_cur (p_req_id number) IS
54: SELECT to_char(count(paa.assignment_action_id)) ASG_COUNT,
55: paa.action_status ASG_STATUS
56: FROM pay_assignment_actions paa,
57: pay_payroll_actions ppa
58: WHERE paa.payroll_action_id = ppa.payroll_action_id
59: AND ppa.request_id = to_number(p_req_id)
60: AND ppa.business_group_id = ln_business_group_id
61: AND ppa.effective_date =
143: CURSOR asg_roe_mag_info_cur (p_req_id number) IS
144: SELECT to_char(count(paa.assignment_action_id)) ASG_COUNT,
145: paa.action_status ASG_STATUS
146: FROM pay_assignment_actions paa,
147: pay_payroll_actions ppa
148: WHERE paa.payroll_action_id = ppa.payroll_action_id
149: AND ppa.request_id = to_number(p_req_id)
150: AND ppa.business_group_id = ln_business_group_id
151: AND ppa.effective_date =