APPS.BOM_SUBSTITUTE_COMPONENT_API dependencies on MTL_PARAMETERS

Line 161: FROM mtl_parameters a

157: stmt_num := 1;
158: LOOP
159: UPDATE bom_sub_comps_interface ori
160: SET organization_id = (SELECT organization_id
161: FROM mtl_parameters a
162: WHERE a.organization_code = ori.organization_code)
163: WHERE process_flag = 1
164: AND upper(transaction_type) in (G_Insert, G_Delete, G_Update)
165: AND (UPPER(interface_entity_type) = 'BILL'

Line 170: FROM mtl_parameters b

166: OR interface_entity_type is null)
167: AND organization_id is null
168: AND organization_code is not null
169: AND exists (SELECT organization_code
170: FROM mtl_parameters b
171: WHERE b.organization_code = ori.organization_code)
172: AND rownum < G_rows_to_commit;
173: EXIT when SQL%NOTFOUND;
174: COMMIT;