APPS.BOM_REFERENCE_DESIGNATOR_API dependencies on MTL_PARAMETERS

Line 140: FROM mtl_parameters a

136: stmt_num := 1;
137: LOOP
138: UPDATE bom_ref_desgs_interface ori
139: SET organization_id = (SELECT organization_id
140: FROM mtl_parameters a
141: WHERE a.organization_code = ori.organization_code)
142: WHERE process_flag = 1
143: AND upper(transaction_type) in (G_Insert, G_Delete, G_Update)
144: AND (UPPER(interface_entity_type) = 'BILL'

Line 149: FROM mtl_parameters b

145: OR interface_entity_type is null)
146: AND organization_id is null
147: AND organization_code is not null
148: AND exists (SELECT organization_code
149: FROM mtl_parameters b
150: WHERE b.organization_code = ori.organization_code)
151: AND rownum < G_rows_to_commit;
152: EXIT when SQL%NOTFOUND;
153: COMMIT;