555: ,0
556: ,0
557: ,0
558: ,0
559: FROM dual
560: WHERE NOT EXISTS
561: (SELECT 1 FROM pay_gb_year_end_values_v b
562: WHERE b.assignment_action_id = c_assignment_action_id
563: AND b.reportable <> 'N'
1354: --
1355: PROCEDURE eoy_control IS
1356: --
1357: cursor get_errored_actions(c_payroll_action_id number) is
1358: select '1' from dual where exists
1359: (select action_status
1360: from pay_assignment_actions
1361: where payroll_action_id = c_payroll_action_id
1362: and action_status = 'E');