DBA Data[Home] [Help]

APPS.PAY_GB_EOY_MAGTAPE dependencies on DUAL

Line 559: FROM dual

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'

Line 1358: select '1' from dual where exists

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');