APPS.BOM_VAL_TO_ID dependencies on BOM_STRUCTURE_TYPES_B

Line 349: l_structure_type_id BOM_STRUCTURE_TYPES_B.STRUCTURE_TYPE_ID%TYPE;

345: FUNCTION Structure_Type( p_structure_type_name IN VARCHAR2,
346: x_err_text IN OUT NOCOPY VARCHAR2 )
347: RETURN NUMBER
348: IS
349: l_structure_type_id BOM_STRUCTURE_TYPES_B.STRUCTURE_TYPE_ID%TYPE;
350: BEGIN
351: SELECT STRUCTURE_TYPE_ID
352: INTO l_structure_type_id
353: FROM BOM_STRUCTURE_TYPES_B

Line 353: FROM BOM_STRUCTURE_TYPES_B

349: l_structure_type_id BOM_STRUCTURE_TYPES_B.STRUCTURE_TYPE_ID%TYPE;
350: BEGIN
351: SELECT STRUCTURE_TYPE_ID
352: INTO l_structure_type_id
353: FROM BOM_STRUCTURE_TYPES_B
354: WHERE STRUCTURE_TYPE_NAME = p_structure_type_name
355: AND ( DISABLE_DATE IS NULL OR DISABLE_DATE > SYSDATE );
356:
357: RETURN l_structure_type_id;