101: IS
102: l_dummy NUMBER;
103: BEGIN
104: SELECT 1 into l_dummy 105: FROM DUAL 106: WHERE EXISTS (
107: SELECT 1
108: FROM bom_operation_resources
109: WHERE operation_sequence_id = p_operation_sequence_id
Line 129: FROM DUAL
125: l_dummy NUMBER;
126: BEGIN
127:
128: SELECT 1 into l_dummy 129: FROM DUAL 130: WHERE EXISTS (
131: SELECT 1
132: FROM bom_resources
133: WHERE organization_id = p_organization_id