DBA Data[Home] [Help]

APPS.BOM_REF_DESIG_PKG dependencies on DUAL

Line 18: SELECT 1 into dummy from dual

14: X_component_sequence_id NUMBER,
15: X_designator VARCHAR2) IS
16: dummy NUMBER;
17: BEGIN
18: SELECT 1 into dummy from dual
19: WHERE NOT EXISTS
20: (SELECT 1 from bom_reference_designators
21: WHERE component_sequence_id = X_component_sequence_id
22: AND component_reference_designator = X_designator

Line 100: FROM dual

96: IF rec_exist IN (0,1) THEN
97: --* If no_data_found for previous query or acd type is 1, checking current block
98: --* DISABLE record exists in the current block
99: SELECT 0 INTO disable_exist
100: FROM dual
101: WHERE NOT EXISTS
102: (SELECT 1 FROM bom_reference_designators
103: WHERE component_sequence_id = X_Component_Sequence_Id
104: AND component_reference_designator = X_Designator