APPS.BOM_ALTERNATE_DESIGNATORS_PKG dependencies on CST_COST_TYPES

Line 97: FROM CST_COST_TYPES

93: WHERE BOM_OPERATIONAL_ROUTINGS.ALTERNATE_ROUTING_DESIGNATOR =
94: X_Alt_Desig_Code
95: UNION
96: SELECT 1
97: FROM CST_COST_TYPES
98: WHERE CST_COST_TYPES.ALTERNATE_BOM_DESIGNATOR =
99: X_Alt_Desig_Code;
100: cur_bom_rtg_cost c_check_bom_rtg_cost%ROWTYPE;
101: BEGIN

Line 98: WHERE CST_COST_TYPES.ALTERNATE_BOM_DESIGNATOR =

94: X_Alt_Desig_Code
95: UNION
96: SELECT 1
97: FROM CST_COST_TYPES
98: WHERE CST_COST_TYPES.ALTERNATE_BOM_DESIGNATOR =
99: X_Alt_Desig_Code;
100: cur_bom_rtg_cost c_check_bom_rtg_cost%ROWTYPE;
101: BEGIN
102: IF X_Organization_Id IS NOT NULL THEN

Line 162: (SELECT 1 FROM CST_COST_TYPES

158: X_Alternate_Designator_Code
159: );
160:
161: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
162: (SELECT 1 FROM CST_COST_TYPES
163: WHERE CST_COST_TYPES.Organization_Id = X_Organization_Id
164: AND CST_COST_TYPES.ALTERNATE_BOM_DESIGNATOR =
165: X_Alternate_Designator_Code
166: );

Line 163: WHERE CST_COST_TYPES.Organization_Id = X_Organization_Id

159: );
160:
161: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
162: (SELECT 1 FROM CST_COST_TYPES
163: WHERE CST_COST_TYPES.Organization_Id = X_Organization_Id
164: AND CST_COST_TYPES.ALTERNATE_BOM_DESIGNATOR =
165: X_Alternate_Designator_Code
166: );
167:

Line 164: AND CST_COST_TYPES.ALTERNATE_BOM_DESIGNATOR =

160:
161: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
162: (SELECT 1 FROM CST_COST_TYPES
163: WHERE CST_COST_TYPES.Organization_Id = X_Organization_Id
164: AND CST_COST_TYPES.ALTERNATE_BOM_DESIGNATOR =
165: X_Alternate_Designator_Code
166: );
167:
168: EXCEPTION