APPS.BOM_VALIDATE dependencies on DUAL

Line 189: SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (

185: IF p_serial_number = '0' THEN
186: RETURN (TRUE);
187: END IF;
188:
189: SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (
190: SELECT NULL FROM mtl_serial_numbers WHERE
191: inventory_item_id = p_assembly_item_id AND
192: current_organization_id = p_organization_id AND
193: serial_number = p_serial_number);

Line 235: SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (

231: IF p_assembly_item_id IS NULL OR p_organization_id IS NULL THEN
232: RETURN 'N' ;
233: END IF;
234:
235: SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (
236: select NULL from bom_bill_of_materials a, bom_alternate_designators b
237: where a.assembly_item_id = p_assembly_item_id
238: and a.organization_id = p_organization_id
239: and a.is_preferred = 'Y'