DBA Data[Home] [Help]

APPS.PAY_GB_EOY_MAGTAPE dependencies on DUAL

Line 614: FROM dual

610: ,0
611: ,0
612: ,0
613: ,0
614: FROM dual
615: WHERE NOT EXISTS
616: (SELECT 1 FROM pay_gb_year_end_values_v b
617: WHERE b.assignment_action_id = c_assignment_action_id
618: AND b.reportable <> 'N'

Line 1555: select '1' from dual where exists

1551: --
1552: PROCEDURE eoy_control IS
1553: --
1554: cursor get_errored_actions(c_payroll_action_id number) is
1555: select '1' from dual where exists
1556: (select action_status
1557: from pay_assignment_actions
1558: where payroll_action_id = c_payroll_action_id
1559: and action_status = 'E');