DBA Data[Home] [Help]

APPS.BOM_UTIL dependencies on BOM_STRUCTURE_TYPES_B

Line 107: FROM bom_structure_types_b

103: RETURN DATE IS
104: l_effective_date DATE;
105: BEGIN
106: SELECT effective_date INTO l_effective_date
107: FROM bom_structure_types_b
108: WHERE structure_type_id = p_structure_type_id;
109:
110: RETURN l_effective_date;
111:

Line 119: FROM bom_structure_types_b

115: RETURN DATE Is
116: l_disable_date DATE;
117: BEGIN
118: SELECT disable_date INTO l_disable_date
119: FROM bom_structure_types_b
120: WHERE structure_type_id = p_structure_type_id;
121:
122: RETURN l_disable_date;
123:

Line 149: FROM bom_structure_types_b

145: l_count NUMBER := 0;
146:
147: BEGIN
148: SELECT count(*) INTO l_count
149: FROM bom_structure_types_b
150: WHERE structure_type_id = p_structure_type_id;
151: IF l_count = 0 THEN
152: RETURN 'N';
153: ELSE